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

Wrong interpretation of spaces and double quotes in CSV files #289

Open
MBuchalik opened this issue Dec 15, 2020 · 0 comments
Open

Wrong interpretation of spaces and double quotes in CSV files #289

MBuchalik opened this issue Dec 15, 2020 · 0 comments
Labels
bug Something isn't working

Comments

@MBuchalik
Copy link
Collaborator

MBuchalik commented Dec 15, 2020

I tried loading a CSV file (using the Adapter) with a structure like this:

column1, column2, "Hi, column3"

Important: There is a space after each comma!

I set columnSeparator to ,

Expected result

I would expect to receive 3 columns like so:

column1
column2
Hi, column3

Actual result

The Adapter now seems not to take double quotes into account as reserved characters. Instead, it produces this result with 4 columns:

column1
column2
"Hi
column3"

I have attached a sample CSV file for you to try it out.
quotes.zip

The problem does not occur if you omit the space after the commas.

@MBuchalik MBuchalik added the bug Something isn't working label Dec 15, 2020
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working
Projects
None yet
Development

No branches or pull requests

1 participant