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.
Thank you in advance
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
There are no labels assigned to this post.