ALTERYX INSPIRE | Join us this May for for a multi-day virtual analytics + data science experience like no other! Register Now

Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
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!

NicoleJohnson
14 - Magnetar
14 - Magnetar

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
7 - Meteor

Works perfectly, thank U

Labels