Euro Symbol in String Field Getting Converted to Â,

[catalystmichael]

When loading from CSV any text/string fields containing a Euro currency symbol are being converted to Â...  as per below image.

I know I could resident load the CSV results and wrap the field in a replace function (replacing with chr(8364) ) but I'd rather tackle it at source and I'm sure there has to be a simpler way.

Any ideas?

[Gysbert_Wassenaar]

Make sure you're using the right encoding when loading the data from the file. Perhaps it's an utf-8 file and you're loading it as ascii with codepage 1252 or it's the other way around.

utf-8: (txt, utf8, embedded labels, delimiter is ',', msq)

ascii: (txt, codepage 1252, embedded labels, delimiter is ',', msq)