export excel file as csv using special character delimiter such as ☼ or ║

%3CLINGO-SUB%20id%3D%22lingo-sub-2030433%22%20slang%3D%22en-US%22%3Eexport%20excel%20file%20as%20csv%20using%20special%20character%20delimiter%20such%20as%20%E2%98%BC%20or%20%E2%95%91%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2030433%22%20slang%3D%22en-US%22%3E%3CP%3Eexcel%20no%20longer%20allows%20you%20to%20export%20in%20csv%20format%20and%20provide%20a%20specific%20delimiter%2C%20you%20must%20simply%20%22save%20as%22%20and%20then%20use%20csv.%20That%20then%20uses%20window's%20regional%20settings%20list%20separator%2C%20which%20does%20allow%20you%20to%20put%20in%20special%20characters%2C%20but%20then%20excel%20replaces%20those%20special%20characters%20with%20non%20special%20characters%20when%20saving%20the%20file.%20for%20example%20%E2%95%91%20is%20replaced%20with%20Q.%20%E2%98%BC%20is%20replaced%20with%20%5B.%20what%20is%20the%20right%20way%20to%20do%20this%3F%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2030433%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

excel no longer allows you to export in csv format and provide a specific delimiter, you must simply "save as" and then use csv. That then uses window's regional settings list separator, which does allow you to put in special characters, but then excel replaces those special characters with non special characters when saving the file. for example ║ is replaced with Q. ☼ is replaced with [. what is the right way to do this??

0 Replies