Working with modifiers in CSV export

[KenRayner]

Hi.

I'm having a real issue with modifiers in the CSV export and I wonder if anyone else has the same issue.

Square's CSV export using commas to delimit the fields in the export *AND* between the modifiers in the modifier field. So you end up with:

"SKU", "Item", "Modifier 1, Modifier 2, Modifier 3", "Something Else"

Now, that's fine - I've written a script to pull out the Modifier field and parse it out - but if someone puts a comma in one of the modifiers, it goes wrong - for example:

Modifier 1, Modifier 2, with a comma in it, Modifier 3

I wish Square would allow the option to have a | delimiter in there or *any other character that's not a comma!*

Any thoughts welcome!

[Lou8]

Hi @KenRayner, thanks for your message and welcome to the Community 👋.

I'd like to look into this for you. Would you be able to take a screenshot of what your file looks like ?