cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Register for our Discovery Summit 2024 conference, Oct. 21-24, where you’ll learn, connect, and be inspired.
Choose Language Hide Translation Bar
lala
Level VII

How to convert HTML structured data into a table with JSL?

With JSL, Can only downlo2021-02-22_12-11-01.pngHTML files.

 

How do I use JSL to convert this file into tabular data?

Thanks!

4 REPLIES 4
lala
Level VII

Re: How to convert HTML structured data into a table with JSL?

I tried the following forms of code and did not get table data:

u="";txt=loadtextfile(u);d1=jsontodatatable(txt);
d1=Open("",HTML Table(1,Column Names(1),Data Starts(2)));
Craige_Hales
Super User

Re: How to convert HTML structured data into a table with JSL?

That data appears to be captured with some other tool and represents a portion of a web page.

JMP can probably open one or more tables from the original web page using file->internet open.

Craige
lala
Level VII

Re: How to convert HTML structured data into a table with JSL?

Thank Craige!

 

I still get text structured file data this way.

2021-02-22_21-30-15.png

I'm not going to use regular to convert this HTML structured file into data.

Craige_Hales
Super User

Re: How to convert HTML structured data into a table with JSL?

The .js extension is a JavaScript file. Normally that file would run in an HTML page and generate some more HTML to embed in the page (JavaScript files are programs and they could do a lot of things; I think this one probably is designed to create a table on the page.)

JMP has no way to run the .js file to get the answer from it. 

JMP expects the table to be embedded in the source when it opens the HTML.

Not sure you can go much further than this.

Craige