User Community
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: 
  • JMP will suspend normal business operations for our Winter Holiday beginning on Wednesday, Dec. 24, 2025, at 5:00 p.m. ET (2:00 p.m. ET for JMP Accounts Receivable).
    Regular business hours will resume at 9:00 a.m. EST on Friday, Jan. 2, 2026.
  • We’re retiring the File Exchange at the end of this year. The JMP Marketplace is now your destination for add-ins and extensions.

Discussions

Solve problems, and share tips and tricks with other JMP users.
View Translated Thread
Hamal22
Hamal22
Level I

Opening URL table with "," issue

Created: Jul 28, 2021 05:16 AM  |  Last Modified: Jun 9, 2023 12:53 PM (980 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 (969 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

Recommended Articles