Quotation marks in .csv export

  • When I create an export to .csv link I find each data value is contained in “quotes” when I open the file.

    "Submitted","next_field_value","next_field_value"

    Is there a way of outputting with just a comma separating the values? I can export to excel and then save as a .csv but excel messes with my date formats and phone numbers.

Viewing 4 replies - 1 through 4 (of 4 total)
  • Plugin Author Michael Simpson

    (@msimpson)

    The quotes is standard CSV. Why do you would need it without? You can change the field delimiter (the comma) but I don’t have a option in the plugin to change the quotes.

    Thread Starter brother

    (@darshi)

    The csv is uploaded to another database and the quotes cause it to fail. Shame they can’t be output without the quotes as the csv seems to function fine without them.

    Plugin Author Michael Simpson

    (@msimpson)

    As a possible work-around, if you pull it into Excel, then format the numeric cells as “Text”, then export to CSV, it might preserve your number format. I’m not sure, but it might be worth a try.

    Hi,

    Can just a little help
    How can I export data from the subscriber and Excel CSV file

    What is the procedure?

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Quotation marks in .csv export’ is closed to new replies.

Tags