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: 
  • Don’t miss your chance to experience Discovery Summit Europe at our best available rate! Early bird registration through 31 Oct.
  • Graph Builder Toolbar streamlines interactive graphing. Creates shortcuts on Report and GraphBuilder Helpers toolbars. Download and install the extension.
  • JMP will suspend normal business operations for our Rest and Recharge Day on Friday, October 2, 2026.
    Regular business hours will resume on Monday, October 5, 2026.

Discussions

Solve problems, and share tips and tricks with other JMP users.
Choose Language Hide Translation Bar
dwaterson
dwaterson
Level III

I have a column of comma separated numbers. Is it possible to separate each number into its own column?

Sep 11, 2014 06:40 PM (12528 views)

I have a column of comma separated numbers. Is it possible to separate each number into its own column?

0 Kudos
1 ACCEPTED SOLUTION

Accepted Solutions
Jeff_Perkinson
Community Manager Jeff_Perkinson
Community Manager Community Manager
Solution

Re: I have a column of comma separated numbers. Is it possible to separate each number into its own column?

Created: Sep 12, 2014 09:09 AM  |  Last Modified: Oct 28, 2016 6:13 AM (14766 views)  |  Posted in reply to message from dwaterson 09-11-2014

The Text to Columns, Version 2 add in will help you out here.

-Jeff

-Jeff

View solution in original post

0 Kudos
2 REPLIES 2
Jeff_Perkinson
Community Manager Jeff_Perkinson
Community Manager Community Manager
Solution

Re: I have a column of comma separated numbers. Is it possible to separate each number into its own column?

Created: Sep 12, 2014 09:09 AM  |  Last Modified: Oct 28, 2016 6:13 AM (14767 views)  |  Posted in reply to message from dwaterson 09-11-2014

The Text to Columns, Version 2 add in will help you out here.

-Jeff

-Jeff
0 Kudos
dwaterson
dwaterson
Level III

Re: I have a column of comma separated numbers. Is it possible to separate each number into its own column?

Sep 12, 2014 10:31 AM (12100 views)  |  Posted in reply to message from Jeff_Perkinson 09-12-2014

Hi Jeff,

Thank you for the Text to Columns add-in. It loaded well and ran well. It did take some time to go through the >5 million rows of data and >40 comma separated values, around 5 mins. So much better than creating a programming each column myself as that would take much longer!

Dianne

Recommended Articles