TRIM THE DIGITS INTO ONE

[dunkindonut7777]

Hi I have a data here that I want to trim down the leading zeros in the left side:

Code:        Expected Code:

000              0

002              2

023              23

016              16

Can you help meout with this one pls?

[Chantelb]

Hi @dunkindonut7777 ,

You can use Trimleft and Regexmatch for when it is all zeros:

[atcodedog05]

Hi @dunkindonut7777 

You can use ToNumber([Code:]) to trim all not-required zeros.

Workflow:

Hope this helps : )

[vsoni]

this article goes through this:

https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/How-To-Remove-Leading-Zeros-From-a-...

TL;DR: use TrimLeft to remove '0' from the left of your fields.