Hello,
Looking for a formula that needs to ensure that after the first "-" or if there is no dash then after the letter commodity code, the number length should be 5 digits by adding leading zeroes. If there are two "-", second dash length should be changed to two by adding a single leading 0.
See below:
Thanks in advance!
Looking for a formula that needs to ensure that after the first "-" or if there is no dash then after the letter commodity code, the number length should be 5 digits by adding leading zeroes. If there are two "-", second dash length should be changed to two by adding a single leading 0.
See below:
Thanks in advance!
10ZE-1307 | 10ZE-01307 |
05WR-14 | 05WR-00014 |
05PL-1 | 05PL-00001 |
33UA859 | 33UA00859 |
05PW859 | 05PW00859 |
05PA-1002 | 05PA-01002 |
05WC-TT199-1 | 05WC-TT00199-01 |
05WC-TT20-01 | 05WC-TT00020-01 |
05WC-PV1490-1 | 05WC-PV01490-01 |
05PL-1A | 05PL-00001A |
05UA859A | 05UA00859A |
33WC-AXL120J-1 | 33WC-AXL01320J-01 |