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.
Thanks
Discussion posts and replies are publicly visible
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).
regexreplaceall("^0*","00000012345608912","")
Thanks Mike!
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.