This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Choose Language Hide Translation Bar
Hamal22
Hamal22
Level I

Opening URL table with "," issue

Created: Jul 28, 2021 05:16 AM  |  Last Modified: Jun 9, 2023 03:53 PM (270 views)

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.

0 Kudos
1 REPLY 1
Craige_Hales
Super User Craige_Hales
Super User

Re: Opening URL table with "," issue

Jul 28, 2021 07:46 AM (259 views)  |  Posted in reply to message from Hamal22 07-28-2021

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
0 Kudos