I have a Text string "00000012345608912"
regexreplaceall("0*$","00000012345608912",""), This will remove the 0 in tail.
I want result to be 12345608912, remove the first leading 0 numbers.
As far as I know you need to use the "^" operator to indicate that you want the match to be from the beginning of the string (you currently have it set to match to the end of the string).
This working perfetly!
Another question is how to add leading zero to make string 10 digital?
For example I have number 15423, my result should be 0000015423,
number 234, then the result should be 0000000234
How should I do that?
I'm not sure you can do that with the regex function, but i'm guessing you could make use of something like the Appian function padLeft().
Thanks, I figure this out.
I can use text(7324314,"0000000000") to make this happened.
ooh, that's handy, that way didn't occur to me.
Discussion posts and replies are publicly visible
© 2020 Appian. All rights reserved.