Wednesday 10 October 2012

Salesforce CSV How to retain Chinese Characters


Sales Force CSV work around for Chinese characters. This Work around may work if you need  to do Japanese / Korean etc.


Scenario


Microsoft Excel xls file saved as file as a CSV looks ok, however when close and open the CSV file up again it looks different with something else.


























MARUBENI



UNIQLO



China (CH)



香港



MARUBENI



UNIQLO



China (CH)



香港



MARUBENI



UNIQLO



China (CH)



香港




Ie after you reopen with MS Excel it looks like this

























MARUBENI



UNIQLO



China (CH)



??



MARUBENI



UNIQLO



China (CH)



??



MARUBENI



UNIQLO



China (CH)



??




**I have tried changing system language local in the OS, still does the same.**


I used OpenOffice Calc to open the XLS file to text CSV,






However when I open the file CSV file saved with OppenOffice in Excel, it still looks like this


























MARUBENI



UNIQLO



China (CH)



香港



MARUBENI



UNIQLO



China (CH)



香港



MARUBENI



UNIQLO



China (CH)



香港




The Trick is :


Open the CSV file you just created with OpenOffice in Notepad. Then save the file as a CSV ( encoding as UTF-8 ) – you can save as something else or replace.


 



 When you open theCSV file with MS Excel, you should be able to retain the characters.

























MARUBENI



UNIQLO



China (CH)



香港



MARUBENI



UNIQLO



China (CH)



香港



MARUBENI



UNIQLO



China (CH)



香港




Ps, took me 2 days to figure out. Site depends on Banner adds. Googling didnt help. Now hopefully googleing will help get you to this page.





No comments:

Post a Comment