Convert tag values and add a leading zero

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 :slight_smile:

You could try an action of the type "Format value" for TRACK
Format string: $if($eql($len(%track%),2),0%track%,%track%)

1 Like

This looks perfect, thank you, ohrenkino - excellent stuff :slight_smile: