cancel
Showing results for 
Search instead for 
Did you mean: 
Due to an issue with YouTube, inserting videos in your emails is showing an error. Until they are able to resolve this issue, we recommend using a different video hosting service. We will continue to monitor this outage and update you as we have more information.

Uploading .csv using commas within the content, no separation of variables

Highlighted
Occasional Organizer

Uploading .csv using commas within the content, no separation of variables

Hello--

 

Hoping someone can troubleshoot this for me as it's the weekend. I'm uploading a .csv into a static segment and it contains many custom fields. Some cells contain commas within that content and the system recognizes it as separate fields even though the commas are within sentences within one column (across multiple cells in that column). Does anyone know how to get this to populate under ONE custom field type, and not separate the sentences after every comma within that excel column and its separate cells?

 

Let me know if you have any questions!

 

Thank you in advance!

1 REPLY 1
Moderator

Re: Uploading .csv using commas within the content, no separation of variables

Hello @VictoriaN765,

 

When using a .csv file separating text by a comma is literally the point of the file type. You may want to try using a different file type such as .xls or .xlsx.

 

Are you importing this file from our website or through the API?


Regards,
Jimmy D.
Tier II API Support Engineer