Skip to main content
L
lanan
January 12, 2022
Question

Convert number to digits

  • January 12, 2022
  • 2 replies
  • 0 views

Hi

I want to convert the number to 8 digits for example if the ID equals 19 the result should be 00000019 by adding six zeros before the value.can I solve this proplem using for each  ? 

    2 replies

    stefanhelzle0001
    stefanhelzle0001
    Brainy
    January 12, 2022

    Did you check the text() function? A formatting pattern like "00000000" should get you what you want.

    bharathwajanr0001
    bharathwajanr0001
    January 12, 2022

    text(ri!num, "00000000"), rule input - num would be of type interger(number) . you can also validate for null as well, because if you pass null value to tezt function , you will get an error. Check the null validation and call the text function as given above.

    Terms & ConditionsAccessibility statement