Hello, I'm new to talend, and I got a problem today when i read a excel file contains polish characters, and output to csv file. the workflow is tfileinputExcel->tmap->tfileoutputdelimited all the special character, like '??', became '?'. I try to set both of input and output encoding to 'UTF-8' or 'ISO-8859-15' in the advanced settings , but it did not work. I couldn't find solution in forum, can anybody please help? Thanks.
Hi Luo Jun,
the output back to an excel file works in my test case.
Did you add the input file to the meta data? Did you see the '?' also in preview?
Best regards
Frank
Em, sorry ... What I mean: You wrote that special polish characters became '?' in csv. Do you open that file in Excel? My test case reads an xls-file and outputs it to an csv- and an xls-file. I can open both files in Excel. The xls-file is shown correct, but not the csv-file. When I open the csv-file with Notepad I can see the special polish characters.
I have changed my computer 'region and language', change system region from Chinese to English,
then, the csv file can be opened in notepad correctly, and also right when I open the file from Data-?from text in Excel.
but not right in Excel direct opening.
Also, I have test this in amazon cloud, original English OS, it the same to the case one.
So, it seems that the issue is related to system configuration.
can anyone help?
