2

I'm exporting a CSV file generated with the help of CHCSVParser, using NSUTF8StringEncoding. Since now everything worked perfect, the fields only had text or numbers, but today I tried to add a Currency field where it shows a currency symbol written in a UITextfield.

If a upload the .csv file to Google Docs the symbols shows correctly but if I export it to Excel with the text wizard it shows € (this is for EURO symbol).

Does anyone know how to make excel show the symbol correctly?

thewinger
  • 79
  • 1
  • 8
  • I only know this is probably an encoding problem (from reading SO posts). I can't help you with that, but now you know at least what to search for. – 11684 Apr 04 '13 at 08:17
  • Thank you! I'll keep researching in that topic – thewinger Apr 04 '13 at 12:39
  • http://stackoverflow.com/questions/4351985/converting-unicode-to-windows-1252-for-vcards - This link should be helpful – Vikash Singh Aug 12 '14 at 11:25

1 Answers1

2

I had to use NSUTF16BigEndianStringEncoding to make excel understand anything.

Olle Sjögren
  • 5,315
  • 3
  • 31
  • 51
exaviore
  • 101
  • 4
  • At the end what I did was to save the value for the currency as the international symbol (i.e. EUR, GBP, etc). Next time I'm in the same situation I'll use your approach. – thewinger May 19 '13 at 16:05