Skip to main content

"Dataloader IO" with MacBook, CSV files issue

 

All, I am using Dataloader IO on a Macbook, when I save an Excel file as a CSV UTF-8 *Comma Delimited" .csv and then open the file up in a text file, the columns are separated by ;  I then have do a 'replace all' action, to replace ; with a comma ,

 

The issue is that I have some text fields which have commas in the field content. So what happens after saving the file and reopening it, you have more columns than field headings.

 

However, when I do this on a Windows machine I do not get the same issues. (via VPN)

 

Any Apple computer users out there, please help me. I also never managed to download the 'dataloader' from SF, itself onto the Mac.

 

Regards,

 

David

0/9000