topic Re: I have a column of comma separated numbers. Is it possible to separate each number into its own column? in Discussions https://community.jmp.com/t5/Discussions/I-have-a-column-of-comma-separated-numbers-Is-it-possible-to/m-p/9504#M9331 <HTML><HEAD></HEAD><BODY><P>Hi Jeff,</P><P>Thank you for the Text to Columns add-in. It loaded well and ran well. It did take some time to go through the &gt;5 million rows of data and &gt;40 comma separated values, around 5 mins. So much better than creating a programming each column myself as that would take much longer!</P><P><SPAN __jive_emoticon_name="happy" __jive_macro_name="emoticon" class="jive_macro jive_emote" src="https://community.jmp.com/7.0.1.0/images/emoticons/happy.png"></SPAN>Dianne</P></BODY></HTML> Fri, 12 Sep 2014 14:31:43 GMT dwaterson 2014-09-12T14:31:43Z I have a column of comma separated numbers. Is it possible to separate each number into its own column? https://community.jmp.com/t5/Discussions/I-have-a-column-of-comma-separated-numbers-Is-it-possible-to/m-p/9502#M9329 <HTML><HEAD></HEAD><BODY><P>I have a column of comma separated numbers. Is it possible to separate each number into its own column?</P></BODY></HTML> Thu, 11 Sep 2014 22:40:43 GMT https://community.jmp.com/t5/Discussions/I-have-a-column-of-comma-separated-numbers-Is-it-possible-to/m-p/9502#M9329 dwaterson 2014-09-11T22:40:43Z Re: I have a column of comma separated numbers. Is it possible to separate each number into its own column? https://community.jmp.com/t5/Discussions/I-have-a-column-of-comma-separated-numbers-Is-it-possible-to/m-p/9503#M9330 <HTML><HEAD></HEAD><BODY><P>The <A href="https://community.jmp.com/docs/DOC-6082" target="_blank">Text to Columns, Version 2</A> add in will help you out here.</P><P></P><P>-Jeff</P></BODY></HTML> Fri, 28 Oct 2016 13:13:42 GMT https://community.jmp.com/t5/Discussions/I-have-a-column-of-comma-separated-numbers-Is-it-possible-to/m-p/9503#M9330 Jeff_Perkinson 2016-10-28T13:13:42Z Re: I have a column of comma separated numbers. Is it possible to separate each number into its own column? https://community.jmp.com/t5/Discussions/I-have-a-column-of-comma-separated-numbers-Is-it-possible-to/m-p/9504#M9331 <HTML><HEAD></HEAD><BODY><P>Hi Jeff,</P><P>Thank you for the Text to Columns add-in. It loaded well and ran well. It did take some time to go through the &gt;5 million rows of data and &gt;40 comma separated values, around 5 mins. So much better than creating a programming each column myself as that would take much longer!</P><P><SPAN __jive_emoticon_name="happy" __jive_macro_name="emoticon" class="jive_macro jive_emote" src="https://community.jmp.com/7.0.1.0/images/emoticons/happy.png"></SPAN>Dianne</P></BODY></HTML> Fri, 12 Sep 2014 14:31:43 GMT https://community.jmp.com/t5/Discussions/I-have-a-column-of-comma-separated-numbers-Is-it-possible-to/m-p/9504#M9331 dwaterson 2014-09-12T14:31:43Z