Forum Discussion
Jacky_Phan
6 years agoIdeator I
Skyler C.
You mentioned the correct point, it is because of spreadsheet editors that automatically surrounds double quotes by this rule: "Fields with embedded commas or double-quote characters must be quoted" which described in https://en.wikipedia.org/wiki/Comma-separated_values#Basic_rules.
I tried to use Open Office Calc tool to open an EXCEL file, then save it as CSV without Text Delimiter. It worked as expected.
Thank you very much!
Skyler_Crossman
6 years agoIdeator I
Jacky,
You're welcome, glad to help! Most of my work with the batchloader has been in text editors, so I'm used to spotting errant quotations. Prior to remembering Open Offic Calc could save without the delimiter, I had a regular expression doing the job. Calc is much easier!
Skyler