Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

copy File with file name with chinese characters

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.
Labels (2)
3 Replies
talendtester
Creator III
Creator III

Have you tried using an escape character before each chinese character?
Anonymous
Not applicable
Author

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 .
talendtester
Creator III
Creator III

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("", "");