Configuring the output component and executing the Job
-
Double-click tLogRow to open its Basic
settings view in the Component tab.
-
Click Sync columns to retrieve the schema from the
preceding component. -
Select Table (print values in cells of a table) in the
Mode area. - Press F6 to run the Job.
The normalized numbers are written in Run view:
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 |
.-----------------+---------------------. | tLogRow_1 | |=----------------+--------------------=| |kansuji |normalized_arabic_num| |=----------------+--------------------=| |〇〇七 |7 | |一〇〇〇 |1000 | |三千2百２十三 |3223 | |15,7 |157 | |一万 |10000 | |負一千一百五十八 |-1158 | |１．２万３４５．６７ |12345.67 | |１．２万３４５．６三 |12345.63 | |4,647.100 |4647.1 | |七十五點四零二五 |75.4025 | |万 |10000 | |億 |100000000 | |兆 |1000000000000 | |京 |10000000000000000 | |垓 |100000000000000000000| |九百八十三万 六千七百三 |9836703 | |二十億 三千六百五十二万 千八百一|2036521801 | |¥百二十三 |¥123 | |百二十三円 |123円 | '-----------------+---------------------' |
The tJapaneseNumberNormalize supports Japanese numbers written
using a sequence of kanji numerals: 〇〇七 becomes 7.
The tJapaneseNumberNormalize supports Japanese numbers written
using a combination of kanji and Arabic numbers: 三千2百２十三 becomes 3223.
The decimal comma is not kept in the normalized numbers returned by the
tJapaneseNumberNormalize component. As a result, 4,647.100
becomes 4647.1 and 15,7 becomes 157. If the input numbers use the decimal comma as
the decimal separator, you must replace the decimal comma with a decimal point.
The input numbers can use a comma to separate groups of thousands: 4,647.100 becomes
4647.1. The tJapaneseNumberNormalize component also removes
trailing zeros from the input number.
The tJapaneseNumberNormalize supports large kanji numbers: 兆六百万五千一
becomes 1000006005001.
Users Today : 35
Users Yesterday : 29
This Month : 380
This Year : 3731
Total Users : 20985
Views Today : 222
Total views : 57547
Who's Online : 1