I put data into database via tExcelInput. I'm Japanese. XLSX-type Excel file have character plus the Japanese syllabary. For example, my expecting result is '???'. But the actual is '???????'. I don't need the Japanese syllabary.
Some Japanese resolve the problem in Perl. XLSX file take first t-tag plus t-tag in rPh-tag. <t>???</t> <rPh sb="0" eb="3"> <t>????</t> </rPh>
You suggest a solution in which the XML structure of the Excel file will be changed or parts of it ignored?
I would suggest you do this based on the actual String. You could do this in an expression within a tMap:
row1.japanese_string.replaceAll("
???", "")
I have no clue about Japanese language but if the syllabary is always the same, this would work.
In Japanese, replace method is not effective for Japanese syllabary since Japanese syllabary is always different.
It depends on the typing.
The standard Japanese Kanji have 3000 characters. So by replace method, I must make 3000 conditions for Japanese syllabary...
For example, Japanese syllabary on input "???" is sometime "????", sometime "?????" ...
I don't know you can understand.
I tried this "
MyStringTable.java" code on Talend with tJava.
But I got the error message below
[color=#555555][font=-apple-system, BlinkMacSystemFont, Segoe UI, Helvetica Neue, Hiragino Kaku Gothic ProN, ????, meiryo, sans-serif]
"llegal modifier for the local class MyStringsTable; only abstract or final is permitted"[/font][/color]
