TRIM THE DIGITS INTO ONE

Question

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?

vsoni · Answer

this article goes through this:

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

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

atcodedog05 · Answer

Hi @dunkindonut7777

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

Workflow:

Hope this helps : )

trim 0.yxmd

Chantelb · Answer

Hi @dunkindonut7777 ,

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

Trimleft.yxmd