Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

catalystmichael
New Contributor III

Euro Symbol in String Field Getting Converted to Â,

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

CaptureToday.PNG

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?

1 Reply

Re: Euro Symbol in String Field Getting Converted to Â,

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)


talk is cheap, supply exceeds demand
Community Browser