Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

How do I left trim leading zeros from alphanumeric string?

anthony123
8 - Asteroid

Hi I tried using Regex tool , but that removed all zeros in my string. Here are examples of fields that I would like all leading zeros trimmed. The difficult part is that there's not a whole lot of consistency across these alphanumeric strings:

 

000000075771
000EPTOS CS
00000004610
000000TESO
000000084440

 

I would like these results:

 

75771

EPTOS CS

4610

TESO

84440

 

Can anyone help with this? Thanks!

3 REPLIES 3
NicoleJohnson
ACE Emeritus
ACE Emeritus

Use the TrimLeft formula!

 

TrimLeft([Field1],"0") should do the trick...

 

Cheers,

NJ

anthony123
8 - Asteroid

Thanks! Not sure why it didn't work the first time.

adrilarotta
8 - Asteroid

Works perfectly, thank U

Labels