1

I need to right pad this with leading zeros to a length of 3 in the output (which is fixed length text)

Examples:

A becomes A00

AB becomes AB0

ABC becomes ABC

Please help.

1 Answers1

0

You could do simply:

substring(concat($your-string, '000'), 1, 3)

Note that this means that "ABCD" becomes "ABC".

michael.hor257k
  • 113,275
  • 6
  • 33
  • 51