Forum Discussion

Pakhi's avatar
Pakhi
New Contributor III
4 years ago

How to add leading 0 in a particular column value to make it fixed 9 digit number

Hi All, I have a scenario in which I have to add leading 0 to make all over length as 9 of the value. If the value is of length 1 then I will add 8 zeros and if the value is of 4 digit lenght then ...
jcornelius's avatar
jcornelius
New Contributor III
4 years ago

use .concat(‘00000000’).concat($Input).slice(-8)

  • Pakhi's avatar
    Pakhi
    New Contributor III
    4 years ago

    This is not working. Can you explain little more

    $value : 1234
    I want it as 000001234

    $value : 12345
    I want it as 000012345

    total length = 9