I tried with UTF - 8 but all the special characters became question marks when i use universal data writer and write to txt.
I also tried with csv and spreadsheet reader. With csv, the characters turn into other special char so didnit preserve the original. And with spreadsheet reader, the special characters are preserved, but changed some regular letters to ?.
With the spreadsheet reader, when I viewed the debug data, those characters are just fine. But when I open the output file in excel, the ? marks start to appear.
Why is that?
I also tried with csv and spreadsheet reader. With csv, the characters turn into other special char so didnit preserve the original. And with spreadsheet reader, the special characters are preserved, but changed some regular letters to ?.
With the spreadsheet reader, when I viewed the debug data, those characters are just fine. But when I open the output file in excel, the ? marks start to appear.
Why is that?
-
Hi,
UTF-8 charset has to be set on both reader and writer components. You can try to open created file with your system editor. See attached example.
Hope this helps.
Please sign in to leave a comment.
Comments 2