I am getting issue's with the extracted .csv files from Apex Data-Loader:
While extracting data that contains special characters, the exported .csv file doesn't show the special character as they were seen in Salesforce UI, but they can changed to something different special character. [ so how to extract them as they were seen in salesforce UI ]
The another thing is one of my client getting this problem, when they are extracting the data(containing Korean language) from dataloader in .csv file the data got broken with many rows when we open it with correct procedure as mentioned below:
a. Opening a new excel sheet, then going to "Data" tab and then clicking on 'From Text' option b. Then selecting the file(,csv extracted by dataloader) and using these settings:- c. Step 1: Delimited & File Origin- 65001: Unicode(UTF-8) d. Step 2: Delimeter - Tab and Comma e. Step 3: Column data format - Text for text type data and Data for date type data
Please help me with these issue's.