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?

Replacing a single character in alteryx

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:

Account Numbers starting with zero.PNG

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?

Expression

Accepted answers

alexnajm

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

binu_acs

@jkibazo

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

All comments

alexnajm

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

binu_acs

@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

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703