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

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

lala — Fri, 09 Jun 2023 22:06:35 GMT

With JSL, Can only downloHTML files.

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

Thanks!

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

lala — Mon, 22 Feb 2021 04:05:35 GMT

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)));

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

Craige_Hales — Mon, 22 Feb 2021 12:59:12 GMT

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.

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

lala — Mon, 22 Feb 2021 13:39:42 GMT

Thank Craige!

I still get text structured file data this way.

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

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

Craige_Hales — Mon, 22 Feb 2021 14:04:28 GMT

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.