I’m attempting to create a custom CSV import flow, and am having some difficulties parsing commas in text cells.
If a column in my .csv includes an escaped comma - functioning not as a seperator but as a character - in the form of ““Me, myself, and I”” the CSV importer seems to be parsing the result as three columns
""Me
myself
and I""
Instead of
Me, Myself and I
Which throws the whole thing out of order.
Is there a flag/trick to preventing this behavior?
Bharat is a genius. I’m sure he can edit his code to accommodate.
If not for any reason, there are ways to essentially import CSV files and generate Coda tables from then with simple Coda Formula langauge and it would give you more control over silly characters like that.
If Bharat can’t handle it or is too busy - I can give some pointers.
Hey Billy! My apologies for the late response here.
I am currently in a rural part of India on vacation until January 24th.
Scott is correct in that this will require a change to the pack code; I’m happy to look into that soon as I am back.
In case you’d like to take a stab at fixing it before, you can try to modify the pack by copying the source code here. The logic to modify will be in the function called csvToJson.