Skip to main content

Greetings everyone.
I have a problem using a flat file connector, which I use to convert a fixed length .txt file to xml. the conversion is successful, but the characters present that have accents are converted with the symbol � in the resulting xml. Are there any settings or workarounds to avoid this?

address in the .txt file → 3 AVENUE DES SPÉLUGUES
address in the xml file → 3 AVENUE DES SP�LUGUES

Thanks in advance to anyone who can help me

Usually this is the effect of conversion from ASCII to UNICODE.
You could use a more sophisticated editor like NOTEPAD++ to see what the new character has become.

This post might help you in Arc :-)
Replacing non-ASCII characters in a file | Community (cdata.com)

Thanks for the reply and advice.
I tried to really understand how this symbol is interpreted (and his real value) but this is also displayed to me by opening the xml generated with notepad++

For the moment I found the script you suggested useful, passing the txt file is "corrected" and the char "É" is converted into "E"

For the moment I can proceed like this but I would like to be able to save the exact information data as it is passed to me. I'm trying to understand if I can somehow extend and/or modify the suggested script.

Reply


Virtual Event: Data Virtualization, Reimagined Ma”arch 14, 2024 style=
Terms and ConditionsCookie settings