topic Re: Excel(xlsx) in Talend Studio

Excel(xlsx)

_AnonymousUser — Sat, 14 Jan 2017 03:26:33 GMT

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>

Can I resolve in Talend?

Re: Excel(xlsx)

Anonymous — Mon, 16 Jan 2017 02:42:11 GMT

Hi,
Have you tried to replace your Japanese syllabary by using treplace component?
Best regards
Sabrina

Re: Excel(xlsx)

Anonymous — Mon, 16 Jan 2017 10:55:09 GMT

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.

Re: Excel(xlsx)

_AnonymousUser — Wed, 18 Jan 2017 12:56:33 GMT

Thanks you,xdshi jlolling.

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 guess best way is exclude rPh-tag.

blog.psl.ne.jp/entry/2014/02/06/501
blog.remora.cx/2010/03/annoying-cell-value-with-furigana.html

Re: Excel(xlsx)

Anonymous — Wed, 18 Jan 2017 22:22:08 GMT

Ok, sorry, I have no clue about Japanese.

Re: Excel(xlsx)

Anonymous — Fri, 31 Mar 2017 07:42:38 GMT

I'm toshiHAL.

I found the resolution idea post about this problem on JAVA.

http://qiita.com/wakato46/items/7512ae845fd644b9a342

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]

[color=#555555][font=-apple-system, BlinkMacSystemFont, Segoe UI, Helvetica Neue, Hiragino Kaku Gothic ProN, ????, meiryo, sans-serif] Any idea? or [/font][/color][color=#555555][font=-apple-system, BlinkMacSystemFont, Segoe UI, Helvetica Neue, Hiragino Kaku Gothic ProN, ????, meiryo, sans-serif] alternative code?[/font][/color]

Re: Excel(xlsx)

Anonymous — Fri, 31 Mar 2017 07:43:55 GMT

The resolution post is