Bracketing Commas for Variable Fields in CSV File Upload

(1) Share

Report

Posted on by AnthonyOsborne

I'm manually uploading a CSV File to Customer Voice to email out Survey Invites, in our Personalisation Fields / Variables we have product names and some of those names contain a comma within the string - I've found this has been causing issues with the CSV Import and 'skewing' the personalisation field with it interpreting that comma as a separator.

I've tried replacing the comma with the | symbol, and while it works, it doesn't look good compared to the actual product name; I've also tried using " on the start and end of the value string and some other methods, but all haven't worked. Is there a way to bracket a value in the CSV import so that the value in the personalisation field is imported correctly with the comma in the string but not treating it as a column separator?

I have the same question (0)