3

I am running a report and exporting a .csv for use with our mail system.

The mail system uses comma delimiting, this causes an issue with merging when it encounters a comma in the Organization column.

For instance, If the Organization column contains Company Name, Inc. for a specific record then the merge will place Company Name in the Org column and Inc. in the following Lead Source column.

Can I setup Salesforce to escape the commas in some way, or can I configure it to use a different delimiter method for exported .csv, like pipes?

Improve this question
0
3

I just did a quick Export as CSV test from a report. All the export values were wrapped by double-quotes.

E.g.

"Company Name", "Phone"
"Company Name, Inc.", "123545"

This should indicate that the comma in the company name isn't a delimiter. What is the mail-system? There might be something wrong with their CSV implementation.

From RFC 4180:

Fields containing line breaks (CRLF), double quotes, and commas should be enclosed in double-quotes.

Improve this answer
3
  • We are using phplist v3.0.5. There is an update available, doesn't say anything about this issue in the changelogs though. Suppose I will try to update. – Jared.DAGI May 18 '14 at 4:45
  • I found an old forum post from 2009 that suggests it is an issue with phplist. Of cource, that may no longer be the case with the latest version. – Daniel Ballinger May 19 '14 at 0:06
  • I believe it is an issue with phplist, I opened an issue ticket and they were quick to say that I was not entering the comma into the delimiter field before importing. I assure you I was... I updated to phplist 3.6 and the issue still occurs every time. they say they are unable to reproduce it. – Jared.DAGI May 20 '14 at 1:45

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.