adding leading zeros

[Krish2459_58]

Hi,

I need to add leading zeros

• If last character in a string having one integer  then add three leading zeros.
• If last character in a string having two integers then add two leading zeros.

ex:

ACCL25 = 00ACCL25

ACCL9 = 000ACCL9

Thanks..

[rubenmarin · Accepted solution]

Hi:

If(IsNum(Right(FieldName,2))
  ,'00'& FieldName
  ,If(IsNum(Right(FieldName,1))
    ,'000'& FieldName)) as FieldName2

[MayilVahanan · Accepted solution]

Hi

Try like below

Load *, Repeat(0, 8-Len(field1))&field1 as field2 Inline
[
field1
ACCL25
ACCL9
];

[BrunPierre]

Hi, try the below.

Text(If(Len(KeepChar(FieldName,'0123456789')) =1, '000'&FieldName,
If(Len(KeepChar(FieldName,'0123456789')) =2, '00'&FieldName))) as FieldName2

[JaWa]

Absolutely brilliant! Thank you very much!