community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
#SANTALYTICS

The highly anticipated Alteryx Community tradition is back! We hope you'll join us!

Learn More
We will be upgrading the Gallery to our 2019.4 release this Saturday, December 7th beginning at 9:00am MT. We expect the outage to take last approx. 2.5 hours.
SOLVED

How do I left trim leading zeros from alphanumeric string?

Meteor

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!

Magnetar
Magnetar

Use the TrimLeft formula!

 

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

 

Cheers,

NJ

Meteor

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

Labels