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.
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?