topic Re: How to correctly read CSV files that are not entirely in table format in JSL? in Discussions

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

BabyDoragon — Thu, 03 Jul 2025 08:46:10 GMT

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?

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

jthi — Thu, 03 Jul 2025 08:51:05 GMT

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.

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

BabyDoragon — Thu, 03 Jul 2025 08:58:26 GMT

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?

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

jthi — Thu, 03 Jul 2025 09:16:52 GMT

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

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

BabyDoragon — Thu, 03 Jul 2025 09:20:04 GMT

Attachment is the sample file!~

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

jthi — Thu, 03 Jul 2025 09:28:22 GMT

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