RegEx Tool remove leading zeros

[mstoler]

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 solution]

@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

[mstoler]

Hello,

Thanks I will accept the solution but I also wanted to learn about regular expressions.

Just a question it seems that Alteryx requires parenthesis around the regular expressions?

Michael