Forum Replies Created

Viewing 4 posts - 1 through 4 (of 4 total)
  • Author
    Posts
  • in reply to: Different results in CSV and Normal Mode #23666
    John Cordes
    Participant

    Thanks – I have submitted a zipped file. I presume it does contain embedded newlines but I am unclear just what to do about that.

    in reply to: Different results in CSV and Normal Mode #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.

    in reply to: Different results in CSV and Normal Mode #23654
    John Cordes
    Participant

    Brief follow-up: I have just tried your suggestion of clearing the “Allow newlines in double quotes” check box in the CSV page of the Customize dialog box. That did indeed make my test file display properly. I believe it is working properly for my original source file also but should check some details to be certain. It also made the display in csv mode *much* faster. Thank you for this suggestion. I’m not sure that I understand just what is happening though — have not been able to spend much time on this today.

    in reply to: Different results in CSV and Normal Mode #23653
    John Cordes
    Participant

    Hello Yutaka,
    Thank you for the prompt response. I am glad to hear that the issue is understood and will soon be corrected. I would send you my reduced file, but it still contains data involving other people which should probably be kept private. Even though I have pared it down a lot from the original, it is not easy to work with (mostly because of the large number of columns still present), so is difficult to ‘clean’. I would be glad to try out a new test version, if you would care to send it to me when ready. I am not sure if the source file contains embedded newlines but will look into that later.

Viewing 4 posts - 1 through 4 (of 4 total)