How can I import a CSV file with a comma in a string value?

mbergmann

Hello everybody, I have problems importing a CSV file that looks like this:

CSV-File:
id,name
1,Bergmann, Marvin

In Xano it looks like that:
id: 1
name: Bergmann

And not like that:
id: 1
name: Bergmann, Marvin

Can somebody please help? Thanks a lot!

Ray Deck

How are you doing the import? If the text is not escaped, (we often wrap a string with quotation marks to handle this situation - but that's not always available) you'll need to set up some rules to handle this split situation. Xano can do that by setting up an upload with a function stack using CSV functions but the built-in one-click CSV import won't work quite right.

We've done our share of weird text file parsing at State Change Pro and in our daily office hours - sometimes data doesn't come in the way we might hope. Working on those hardest 5% of problems is what we do together.