Forum Discussion

mtran21's avatar
mtran21
New Contributor III
5 years ago

Expression to keep leading zero in a number

I am using Mapper snap to map an integer column from database to CSV file. How do you write expression for this field “MyNum” to keep the leading zero in the csv file? like 04567

Thanks

3 Replies

  • igormicev's avatar
    igormicev
    Contributor
    5 years ago

    Hi @mtran21

    What is the desired length with leading zeroes? you could have examples like 00123, 01234, or 00001.
    Under the assumption that you know the length, for example 5 here, then you could do something like:

    ("00000"+$MyNum.toString()).slice(-5)

    and you’ll always be having leading zeros and lengths == 5.

    HTH

  • marija_nikolovs's avatar
    marija_nikolovs
    New Contributor II
    5 years ago

    Hi @mtran21

    In mapper you just do next: “0” + $MyNum and you have “MyNum” as string now.

    Hope this is what you needed.

    BR