SIGN UP

Data with commas is being split up during serialization

By: George Plumley | Asked: 09/26/2023
Forums › Category: General questions › Data with commas is being split up during serialization
0 Vote Up Vote Down
George Plumley asked 1 year ago
I'm importing some data into a FF form. Among the data is a field for categories. Some of these category names contain commas. I can see in my CSV file that in cases where there's a comma in the name, the spreadsheet program has properly enclosed the data with " marks. When the FF import process takes place, however, FF  splits up the category name at the point where the comma occurs. Anyone know what I'm doing wrong?    
Attachments
Screen-Shot-2023-09-26-at-3.54.06-AM.png
Screen-Shot-2023-09-26-at-4.25.48-AM.png
2 Answers
0 Vote Up Vote Down
Victor Font answered 1 year ago
I never upload CSV content without field delimiters. Your CSV is inconsistent. You have some fields wrapped in quotes and others without. Try wrapping all fields in quotes and use "," as the delimiter like in this example: "field1","field2a,field2b","field3".
0 Vote Up Vote Down
George Plumley answered 1 year ago
Thanks for that, Victor. When I look at the Exports generated by FF, I see that they use the delimiter "," so it's my spreadsheet program (Numbers for Mac) which is not maintaining that structure and is exporting with just a , delimiter. I'm not seeing any option for choosing my delimiter, so will look into using another program.

Making the Best WordPress Plugin even better - Together

Take on bigger projects with confidence knowing you have access to an entire community of Formidable Experts and Professionals who have your back when the going gets tough. You got this!
Join the community
crossarrow-right