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 ?
Discussion posts and replies are publicly visible
Did you check the text() function? A formatting pattern like "00000000" should get you what you want.
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.