topic Extracting numbers from a set of numbers in a column in Discussions https://community.jmp.com/t5/Discussions/Extracting-numbers-from-a-set-of-numbers-in-a-column/m-p/13607#M12817 <HTML><HEAD></HEAD><BODY><P>Let say you have the following data table with 6 digits numbers in one column (Number 1) and you are interested in extracting only 4 numbers from those 6 numbers into a new column (Derived Numbers). How do you go about doing that? Thanks in advance.</P><P></P><TABLE border="1" class="jiveBorder" height="159" style="border: 1px solid rgb(0, 0, 0); width: 661px; height: 161px;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Number 1</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Derived Numbers</STRONG></TH></TR><TR><TD style="padding: 2px;">201409</TD><TD style="padding: 2px;"></TD></TR><TR><TD>201589</TD><TD></TD></TR><TR><TD>201378</TD><TD></TD></TR><TR><TD>201411</TD><TD></TD></TR><TR><TD>201091</TD><TD></TD></TR></TBODY></TABLE></BODY></HTML> Wed, 29 Jul 2015 14:36:49 GMT jenkins_macedo 2015-07-29T14:36:49Z Extracting numbers from a set of numbers in a column https://community.jmp.com/t5/Discussions/Extracting-numbers-from-a-set-of-numbers-in-a-column/m-p/13607#M12817 <HTML><HEAD></HEAD><BODY><P>Let say you have the following data table with 6 digits numbers in one column (Number 1) and you are interested in extracting only 4 numbers from those 6 numbers into a new column (Derived Numbers). How do you go about doing that? Thanks in advance.</P><P></P><TABLE border="1" class="jiveBorder" height="159" style="border: 1px solid rgb(0, 0, 0); width: 661px; height: 161px;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Number 1</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Derived Numbers</STRONG></TH></TR><TR><TD style="padding: 2px;">201409</TD><TD style="padding: 2px;"></TD></TR><TR><TD>201589</TD><TD></TD></TR><TR><TD>201378</TD><TD></TD></TR><TR><TD>201411</TD><TD></TD></TR><TR><TD>201091</TD><TD></TD></TR></TBODY></TABLE></BODY></HTML> Wed, 29 Jul 2015 14:36:49 GMT https://community.jmp.com/t5/Discussions/Extracting-numbers-from-a-set-of-numbers-in-a-column/m-p/13607#M12817 jenkins_macedo 2015-07-29T14:36:49Z Re: Extracting numbers from a set of numbers in a column https://community.jmp.com/t5/Discussions/Extracting-numbers-from-a-set-of-numbers-in-a-column/m-p/13608#M12818 <HTML><HEAD></HEAD><BODY><P>Thanks, I figured it out Here is screenshot. I used the Left from the Character function group and selected the number of numbers that I want to extract from the original table.</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="9333_NumberExtract-Left.jpg" style="width: 959px;"><img src="https://community.jmp.com/t5/image/serverpage/image-id/1905iED303A7C9BC043D1/image-size/medium?v=v2&amp;px=400" role="button" title="9333_NumberExtract-Left.jpg" alt="9333_NumberExtract-Left.jpg" /></span></P></BODY></HTML> Wed, 19 Oct 2016 00:04:20 GMT https://community.jmp.com/t5/Discussions/Extracting-numbers-from-a-set-of-numbers-in-a-column/m-p/13608#M12818 jenkins_macedo 2016-10-19T00:04:20Z Re: Extracting numbers from a set of numbers in a column https://community.jmp.com/t5/Discussions/Extracting-numbers-from-a-set-of-numbers-in-a-column/m-p/13609#M12819 <HTML><HEAD></HEAD><BODY><P>The screenshot is actually a screenshot from one of data tables, which I was working with yesterday. For this specific example your formula would rather be:</P><P></P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Left(Number 1, 4)</P></BODY></HTML> Thu, 30 Jul 2015 13:57:49 GMT https://community.jmp.com/t5/Discussions/Extracting-numbers-from-a-set-of-numbers-in-a-column/m-p/13609#M12819 jenkins_macedo 2015-07-30T13:57:49Z