Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear Team, @Richard Hall @Xiaodi Shi @Shicong Hong
I have data for some of the columns it's in different language. The language is "THAI". When I try to load the data to a excel sheet, the FNAME, LNAME columns data looks bad.
If ID is less than 13 digits, then concatenate FNAME+LNAME+DOB and keep it in CID.
If ID is more than 13 digits, then concatenate FNAME+LNAME+DOB and keep it in CID.
If ID is equal to 13 digits, then keep the 13 digits in CID.
If ID is null, then concatenate FNAME+LNAME+DOB and keep it in CID.
Thanks in advance.
@Shicong Hong The information in Thai ( FOREIGN LANGUAGE IS NOT DISPLAYED )
Thanks in advance.
Have you tried to use 'UTF-8' encoding to read the data from data source? Take a look at this similar question, it might be helpful.
Regards
Shong
@Shicong Hong
I kept the encoding as "UTF-8" . THE LANGUAGE IS "THAI"
Thanks in advance
What is the encoding of file? You can open the file with notepad++ and click the 'Encoding' tab to see the file encoding.
@Shicong Hong I try to check with the "GOOGLE SEARCH", since I don't have permission to install notepad++ . THAI LANGUAGE encoding is "TIS-620"
I tried changing the encoding with TIS-620 , I can able to see the information, but the information looks somewhat sloppy. ( YOU CAN SEE ON THE SCREENSHOT), the characters looks pretty small.
May I know ? How reliable it will be - when I try to do some functions with it .. like concatenation, splitting the name. ? Will it work out, since the "THAI" language encoding is not in Talend.
Thanks in advance.
I have never processed THAI language, but I see THAI characters always looks small. After reading the data with 'TIS-620' encoding, any problem you have when you try to some function with the data?
Looks good at the moment. !
Appreciate your efforts and replying towards every comment. The code which you share for concatenation, works ! Thanks @Shicong Hong
Great, glad to hear that!