Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

ImportX ignores quoted data #67

Open
ghost opened this issue Mar 21, 2017 · 1 comment
Open

ImportX ignores quoted data #67

ghost opened this issue Mar 21, 2017 · 1 comment

Comments

@ghost
Copy link

ghost commented Mar 21, 2017

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.

@Mark-H
Copy link
Member

Mark-H commented Aug 18, 2017

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.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

1 participant