Hi, would like to ask for some kind assistance with the following query.
Want to convert values from one field to the next adding a leading zero unless the number begins with a 1. For example:
1A = 01A
5B = 05B
7A = 07A
10B = 10B
12A = 12A
Need some logic in an expression to determine to add a zero if the value does not start with a 1, else copy the value as it.
The stumbling block here is thats it alphanumeric value..
Thank you in advance