cancel
Showing results for 
Search instead for 
Did you mean: 
You deserve the best.
Beginning Saturday 2/15 we will be upgrading our phone system to ensure we are providing you with the best possible experience.
Due to this upgrade, we will be limited to Chat support only on Saturday from 10-8 pm ET.
On Monday, President's Day, we plan to have both Chat and Phone support available from 10-6 pm ET on the new system.
Thank you for your patience while we make these important updates.

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

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
Highlighted
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