AnsweredAssumed Answered

How to avoid unreadable text when importing records from CSV files?

Question asked by Alejandro Felix on Aug 6, 2016
Latest reply on Aug 12, 2016 by greatgrey

I'm getting a non coherent result...

I'm importing records from a CSV table that appears to be using Unicode 8 as the original format

When importing text from the full address column, the zeros on the zip code were ignored

That was solved, using " at the begining and at the end of the address

Now it started using strange characters that make unreadable words when it contains accented vowels or ñ, Ñ as well (spanish)

Any ideas to get back a readable text?

 

A sample file is attached

Attachments

Outcomes