Read Tab separated file in JMP from server

ProbitMonster53 — Thu, 08 Jun 2023 16:41:48 GMT

how to read a tab-separated file (or any other delimeter ) in JMP.


dt=Open( 'http://www.<<someDomain>>/tab-separated.csv', text);

Here the first parameter in the Open function is the URL of the file.

file contains below sample, column may contains comma separated values that is why delimiter of file is Tab

column1|column2|column3|column4

1 | 2 | abc,xyz | 3 | 4|

Re: Read Tab separated file in JMP from server

txnelson — Tue, 24 Jan 2023 06:32:47 GMT

This can be handled easily. The Open() function has many options that allow for the handling of different delimiters, etc. The easiest way to generate the correct code, is to use the Data Previewer and then once the first file is input, it will contain the JSL that can be used for the additional files.

To do this, first click on

File=>Open

and navigate to the folder where the file you want to input resides.

Click on the down arrow in the box currently displayed as "All JMP Files ........" and select

A new area in the window will be displayed that will allow you to used different approaches to open the files., Click on

Data (Using Preview)

Select the file you want to open and then click Open

The Preview Window will open

There are different settings you can change on this window, but considering that you specified that you want to use Tabs in addition to Commas, Click on the Delimited fields check box and then check the Tab check box.

A preview of what the different fields will be are displayed in the window. If it is what you want, then click on Next, and when the next window appears, click on Import.

Your data table will appear.

Now to get a copy of the JSL you can just open the Log window and it will list out the JSL that it used to open the data table.

The JSL is pretty straight forward. If you cut and paste this JSL into your script, you can then just change the pointer to the file you want to open, and the Import Settings will handle the End of Field options you changed.

topic Re: Read Tab separated file in JMP from server in Discussions

Read Tab separated file in JMP from server

Re: Read Tab separated file in JMP from server