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 i will add 5 zeros to make it total 9 digits as length.
For Example
Input:
1
2
16
188
1235

Output:
000000001
000000002
000000016
000000188
000001235

Please help

4 Replies

  • jcornelius's avatar
    jcornelius
    New Contributor III

    text1 = “000000000”; //length you want

    text2 = “1234”;

    result = “000000000”.concat(text2);

    0000000001234
    //returns last number of characters
    let result2 = result.slice(-9); //length you want

    000001234

    ‘0’.repeat(9).concat(text2).slice(-9)

  • Pakhi's avatar
    Pakhi
    New Contributor III

    $value.toString().length < 9? ‘0’.repeat(9 - $value.toString().length) +$value: $value

    This is working

    • Pakhi's avatar
      Pakhi
      New Contributor III

      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