Replacing a single character in alteryx

[jkibazo]

Hello,

I am trying to clean out a dataset whereby I want to remove zeros (0) at the beginning of my account numbers and only remain with the remaining digits. My dataset can be seen below:

 

For example if I have 02334566, the new column I want to create should have 2334566 for the new account number. How can I achieve this in alteryx?

[alexnajm · Accepted solution]

ReplaceFirst([Account Number], "0" , "")

[binuacs · Accepted solution]

@jkibazo 

ReplaceFirst([Account Number],”0”,””)

[alexnajm]

Or you could convert it into a number which would remove the zeroes automatically - not my suggestion but a possibility nonetheless.

[rzdodson]

Another way to do it:

Right([Account Number], Length([Account Number])-1)

[jkibazo]

Thank you so much. This works