cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
The Discovery Summit 2025 Call for Content is open! Submit an abstract today to present at our premier analytics conference.
Choose Language Hide Translation Bar
View Original Published Thread

Opening URL table with "," issue

Hamal22
Level I

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.

1 REPLY 1
Craige_Hales
Super User


Re: Opening URL table with "," issue

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?

 

Craige