Hi,
I want my alphanumeric field with the below condition.
if the text is asdf45 I want the output total as 10 digits with Zero's in the front. How can I do that?
When I try doing text(asd45,"0000000000") --> this is not considering the strings present.Thanks!
Discussion posts and replies are publicly visible
I used join array and repeat function and it worked
Probably cleaner to do something with a combination of concat/stripWith/cleanWith/text.
a!localVariables( local!text: "asdf45", concat( stripwith(local!text, "0123456789"), text( cleanwith(local!text, "0123456789"), "0000000000" ) ) )