topic Re: How to read-in singular lines of a txt file and pull data from that file in Discussions

How to read-in singular lines of a txt file and pull data from that file

masonlee98 — Mon, 23 Jul 2018 23:27:39 GMT

The goal of my code is with each iteration of a for loop it will read in a singular line from a txt file, put that data into a variable, and put that variable into a line of code that will pull data from a database.

I have a matlab code that pulls data from an excel sheet and trims the data into a certain number of characters and puts it into a txt file. I can easily change the matlab code to output this data differently if that would be easier for JMP to read in.

I have attached my non-working code.

Re: How to read-in singular lines of a txt file and pull data from that file

gzmorgan0 — Tue, 24 Jul 2018 00:46:59 GMT

Hmmm, your request is unclear to me.

Is your plan run the database extraction fro JMP or Matlab?

JMP can read an Excel file. JMP can also extract data from an Excel file using the Excel Wizard (JMP13 and higher) or using SQL. JMP has ben able to use an Excel workbook as a database since JMP 9. However, to use SQL to extract Excel and you have 64 bit JMP and 32 bit Excel, a one time special setup is needed to define the machine DSN.

That said, this line of JSL from your script

Pnames = open("$Desktop/EPI-1310-EML_V004Pnames.txt");

is opening a table and Pnames is the refernce for that table and Pnames[i] makes no sense.

Does the Pnames.txt file have a header a column header? If not, then uses this code like this

Opendt = Open( "$SAMPLE_IMPORT_DATA/EOF_comma.txt", Table Contains Column Headers( 0 ) );

If you do not have a header, and you Pnames.txt file is multiple lines, where each line is a parameter name, then to get the names use Name = :Column 1[i] .

Yo need to show what Pnames.txt and Pset.txt look like.

Re: How to read-in singular lines of a txt file and pull data from that file

masonlee98 — Tue, 24 Jul 2018 17:11:54 GMT

name = :Column 1[i]; solved the probelm I was having.

Thank you for the quick response.