How do I use JSL to control the bulk import of each column data format of TXT text?

Question

Dear all：
There are multiple TXT format table data in the same path, but I only import one file into JMP at a time.

Since each TXT file has different column names and number of columns, how to use JSL to unify the data to be imported from column 8 to the last column to be set to consecutive number format?Thank you very much!

lwx228 · Answer

This allows me to write the JSL way of importing files in a one-to-one way, which gives me more open() code.A single file has 50, 000 characters of open() code.

txnelson · Answer

I would like a bit more detail on what you mean by "troublesome".  Having JMP parse across a data table with lots of blank columns, and determining which ones to delete, etc. ia a relatively easy thing to do.  So in the past, I have typically taken this approach.

lwx228 · Answer

Well, that's all. Thank you very much!

The actual data of my TXT file are all over 600 columns, some of which may have a lot of null values. JMP automatically determines that these columns are in text format, and as a result, these columns do not have data import, which is troublesome to deal with.