cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
JMP is taking Discovery online, April 16 and 18. Register today and join us for interactive sessions featuring popular presentation topics, networking, and discussions with the experts.
Choose Language Hide Translation Bar
dwaterson
Level III

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

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

1 ACCEPTED SOLUTION

Accepted Solutions
Jeff_Perkinson
Community Manager Community Manager

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

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

-Jeff

-Jeff

View solution in original post

2 REPLIES 2
Jeff_Perkinson
Community Manager Community Manager

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

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

-Jeff

-Jeff
dwaterson
Level III

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

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