Support Article
No Spanish characters when csv read by file listener
SA-19326
Summary
A file listener processes csv files that contain Spanish characters such as ó or ñ. When data is loaded to a data table, the Spanish characters have been converted to an indicator that the characters are not recognized.
Steps to Reproduce
Create a csv file with Spanish characters, load by file listener, check data table
Root Cause
The file listener is configured to read UTF-8 files.
The csv files are saved in ANSI character set.
The characters which are not recognized are present in the ANSI-8 character set, but not the ANSI-7 character set.
Resolution
Provide the files in UTF-8 encoding to match the configuration of the file listerner.
Published February 9, 2016 - Updated October 8, 2020
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.