How to correctly read CSV files that are not entirely in table format in JSL?

[#1]

View more...

When using JSL and the Open() function to read a CSV file, if there are values in non-primary data columns above as shown in the image, how can I correctly read the values in the columns? Using Open() directly results in an error.

Additionally, if I need to read the IDs above the column data, how should I do that?

[#2]

Read the CSV interactively with JMP to allow easier reading from specific rows. You can do it multiple times to first get the metadata and in second open get data. Or you can load it is a text file and parse it into JMP table.

[#3]

I know how to read a file directly, but I need to use JSL to read a large number of CSV files of this type.
Using Open() fails to read them. What should I do?

[#4]

You haven't provided your file so it is difficult to provide proper examples

[#5]

Attachment is the sample file!~

[#6 · Accepted solution]

Using preview 

Now you have your data. Do second open with preview but now just pick your metadata

Then you can move the data over to your original data in many different ways.

After you have this working, you can turn it into a script and loop over your files and repeat the process on all of them. Or optionally you can try to use Multiple File Import to perform as many steps as possible with one MFI run and then cleanup with JSL