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
Myni
Level I

I want change the numbers, 1 ~ 9 to 01 ~ 09 in column

Hello,

 

I have two column, Lot and wafer as shown below.

How can I make wafer_rev column, where the single digit values (1~9) are changed to double digits (ex, 01, 02, ,,,,09. No change in 11~20)

 

Is there a simple script for this ?

Please advise me.

 

Lot

wafer

Wafer_rev

DA1

1

01

FA2

3

03

UJ3

11

11

DS2

9

03

 

Thank you in advance

1 REPLY 1
txnelson
Super User

Re: I want change the numbers, 1 ~ 9 to 01 ~ 09 in column

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.

But if you need it for other reasons, a simple formula to use for the Water_rev column is:

Substr( "0", Length( :Wafer ) ) || :Wafer
Jim