RegEx Tool remove leading zeros

Question

Hello,

I am using the RegEx tool to remove leading zeros.  I am using the expression below,

(^[0]+)

It seems like the RegEx tool requires the left and right parenthesis.  I just wanted to check because it seems that some RegEx tools will also accept

^[0]+

Thanks for the clarification.

Michael

MarqueeCrew · Accepted Answer

@mstoler ,

You should use the string function, TrimLeft().

TrimLeft

TrimLeft(String, y): Removes character in the string (y) from the beginning of the string (String). Y is optional and defaults to trimming white space.

TrimLeft([Field],"0")

This will remove leading zeroes.

Cheers,

Mark