topic Re: copy File with file name with chinese characters in Talend Studio

copy File with file name with chinese characters

Anonymous — Mon, 14 Mar 2016 07:40:45 GMT

Hi ,
I have file with file name having English+chinese character. when I copy file using tftpput fille name change. Chinese character will replace by '?'.
example :
1510??????.pdf becomes 1510??????.pdf
I tried changing encoding type to "UTF-8" but chinese character change to unknown character.
exapmple:
1511?????? Adjust.pdf becomes 1511ã¿¹ã¿¯ã¿¼ã¿¿ç²¾ç®¿ Adjust.pdf
please let me know what solution will be applicable for this case.

Re: copy File with file name with chinese characters

talendtester — Mon, 14 Mar 2016 21:22:16 GMT

Have you tried using an escape character before each chinese character?

Re: copy File with file name with chinese characters

Anonymous — Tue, 15 Mar 2016 14:47:22 GMT

Hi talendtester,
I am picking those files from local and copy on ftp, during run time I dont know which character is english and which is chinese.
so I cant put escape character .

Re: copy File with file name with chinese characters

talendtester — Tue, 15 Mar 2016 15:59:07 GMT

In that case:
1. Get the length of each file's name
2. Pull each character in the file's name 1 character at a time and add an escape chacter before each character.
If you didn't want to keep the Chinese characters, you could use a regular expression to remove everything that wasn't alphabetic or numeric:
string.replaceAll("", "");