Hello JMP Community,
Whilst trying to import CSV files to JMP 15, I noticed that JMP does not recognise a skipped line in the CSV file. Ideally, JMP should recognise it and translate it into a skipped row in the data table. The only two ways I found to make it recognise it is either by opening the CSV file and adding a comma to the empty/skipped line, or by unchecking both the <CR>+<LF> and <CR> boxes in the settings of the import window (File > Import Multiple Files > Settings) and only leaving the <LF> box checked (as opposed to having all three boxes checked). The first solution is laborious if I want to import many CSV files, and the second creates more issues than it solves as the CSV file uses <CR>+<LF> as well. So, I would appreciate if you could let me know how I can overcome this issue efficiently.
Thank you all in advance!
it would be great if you get an answer, you could share it here so others can benefit as well. Thanks