Choose Language Hide Translation Bar
Highlighted
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
Highlighted
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
Article Labels

    There are no labels assigned to this post.