#23664
John Cordes
Participant

Hello Yutaka,
Thank you for the quick update. I have installed 18.0.7 and tried it on a couple of the CSV files I described.
I find myself somewhat puzzled by the results.
First, when I load the smaller test file I mentioned, I do see 109 lines in both modes (csv and normal), no matter whether the “Allow newlines in double quotes” box is cleared or not.
However, when I open the complete file (before I began deleting lines to try to get to a simple test file situation), things are more complicated.
With the ‘newlines’ box cleared, I find the same results in both csv and normal mode: 10,284 lines. There are just 2 lines in the Output window (in csv mode):
(2036): Invalid double quotes.
(2036): Inconsistent number of columns detected.

With the ‘newlines’ box checked, I see 10,284 lines in normal mode (expected result I think) but only 7,883 lines in csv mode. In csv mode for this case the Output window contains these lines:
(2036): Invalid double quotes.
(2036): Inconsistent number of columns detected.
(2082): Invalid double quotes.
(2085): Invalid double quotes.
(2160): Invalid double quotes.
(2170): Invalid double quotes.
(2303): Invalid double quotes.
(2765): Invalid double quotes.

My reduced test file is 203 KB in size, the original file is 2.88 MB. I would be prepared to send either file to you if you would like to check them out yourself.