Wrong interpretation of spaces and double quotes in CSV files

[MBuchalik]

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.