modmore
ImportX ignores quoted data
I am constantly getting the error: Element count do not match. Please check for correct syntax on line [[+line]].
I am using commas as my separator.
I think I have narrowed it down to this: my Excel-exported CSV looks like this:
1997,Ford,E350,"Super, luxurious truck"
Instead of ImportX ignoring the comma after super it is treating it as a seperator.
In this instance ImportX should ignore that comma because the data Super, luxurious truck is surrounded by double quotes.
Want to back this issue? Post a bounty on it! We accept bounties via Bountysource.
This is indeed the case, ImportX uses a very simple approach to parsing CSV which does not check for quotes. In a future update I'd like to rewrite that part of the code to support more of what CSV supports.
