4

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?

0

1 Answer 1

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.

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
    Commented May 18, 2014 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. Commented May 19, 2014 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
    Commented May 20, 2014 at 1:45

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .