1 Reply Latest reply: Aug 8, 2017 5:20 AM by Gysbert Wassenaar RSS

    Euro Symbol in String Field Getting Converted to Â,

    Michael Laverick

      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?