- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
Opening URL table with "," issue
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
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