topic Re: Opening URL table with "," issue in Discussions

Opening URL table with "," issue

Hamal22 — Fri, 09 Jun 2023 19:53:33 GMT

Hi all,

when trying to open URL table I got an issue wit hthe columns,

some of the valiues have "," in them and it cause the valuse to split in several columns,

is there a way to resolve it?

example:

original value in column: "bag,mask,cup"

when I open URL in JSL-> I got 3 seperate columns: "bag" "mask" "cup"

appriciate your support.

Re: Opening URL table with "," issue

Craige_Hales — Wed, 28 Jul 2021 11:46:17 GMT

We may need to see a little more about what you are doing. If you are using Internet Open on a web page containing an HTML table, the values in the table cells go into columns the way you expect. Internet Open (in JMP) shows the tables it found on the page. Unfortunately, not all table-like web pages use an HTML table.

what are you doing to download the URL, and
what are you using in JMP to open the downloaded data?
Is the URL something you can share?