topic Re: I want change the numbers, 1 ~ 9 to 01 ~ 09 in column in Discussions https://community.jmp.com/t5/Discussions/I-want-change-the-numbers-1-9-to-01-09-in-column/m-p/234066#M46412 <P>If what you are attempting to do, is to get your data to order correctly, the easiest thing to do, is to just change the Data Type of the wafer column to numeric.</P> <P>But if you need it for other reasons, a simple formula to use for the Water_rev column is:</P> <PRE><CODE class=" language-jsl">Substr( "0", Length( :Wafer ) ) || :Wafer</CODE></PRE> Sun, 17 Nov 2019 14:27:43 GMT txnelson 2019-11-17T14:27:43Z I want change the numbers, 1 ~ 9 to 01 ~ 09 in column https://community.jmp.com/t5/Discussions/I-want-change-the-numbers-1-9-to-01-09-in-column/m-p/234056#M46411 <P>Hello,</P><P>&nbsp;</P><P>I have two column, Lot and wafer as shown below.</P><P>How can I make wafer_rev column, where the single digit values (1~9)&nbsp;are&nbsp;changed to double digits&nbsp;(ex, 01, 02, ,,,,09. No change in 11~20)</P><P>&nbsp;</P><P>Is there a simple script for this ?</P><P>Please advise me.</P><P>&nbsp;</P><DIV><TABLE border="1" cellspacing="0" cellpadding="0"><TBODY><TR><TD><P>Lot</P></TD><TD><P>wafer</P></TD><TD><P>Wafer_rev</P></TD></TR><TR><TD><P>DA1</P></TD><TD><P>1</P></TD><TD><P>01</P></TD></TR><TR><TD><P>FA2</P></TD><TD><P>3</P></TD><TD><P>03</P></TD></TR><TR><TD><P>UJ3</P></TD><TD><P>11</P></TD><TD><P>11</P></TD></TR><TR><TD><P>DS2</P></TD><TD><P>9</P></TD><TD><P>03</P></TD></TR></TBODY></TABLE></DIV><P>&nbsp;</P><P><SPAN class="tts_area">Thank you in advance</SPAN></P> Sun, 17 Nov 2019 13:49:12 GMT https://community.jmp.com/t5/Discussions/I-want-change-the-numbers-1-9-to-01-09-in-column/m-p/234056#M46411 Myni 2019-11-17T13:49:12Z Re: I want change the numbers, 1 ~ 9 to 01 ~ 09 in column https://community.jmp.com/t5/Discussions/I-want-change-the-numbers-1-9-to-01-09-in-column/m-p/234066#M46412 <P>If what you are attempting to do, is to get your data to order correctly, the easiest thing to do, is to just change the Data Type of the wafer column to numeric.</P> <P>But if you need it for other reasons, a simple formula to use for the Water_rev column is:</P> <PRE><CODE class=" language-jsl">Substr( "0", Length( :Wafer ) ) || :Wafer</CODE></PRE> Sun, 17 Nov 2019 14:27:43 GMT https://community.jmp.com/t5/Discussions/I-want-change-the-numbers-1-9-to-01-09-in-column/m-p/234066#M46412 txnelson 2019-11-17T14:27:43Z