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: 
  • Learn how to build custom Python data connectors and further customize JMP’s Data Connector Framework with the Python Data Connector Demo, available now in the JMP Marketplace!
  • See how to create experiments to support product design and ID useful product features. Register for June 12 webinar, 2pm US Eastern Time.

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 (12190 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 (14428 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 (14429 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 (11762 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