I have been stuck with the following frustrating issue for some days, I hope you can help.
Using Salesforce Data loader I wish to export some objects (Accounts, Contacts, Opportunities) and import them into a sandbox. When I export the Accounts, my csv file gets a strange format for fields that have line breaks. For example querying ID, BillingStreet, BillingCity gives the following csv for one record:
"0012213140hL7LVAA0", "21 Whitetown Road
The same happens for any field I export that have line breaks, Shipping Street, text areas etc. Have anyone encountered this issue and found a solution? It has been a while since I used the data loader, but don't remember having this issue ever.
Any help is greatly appreciated.