amending field

[lancegoh1]

hello,

I'm trying to do a Vlookup using the join tool, but my fields are different. any idea on how should I use the formula tool to remove the "0" so that the join tool can read the field?

Input 1:

account number

123456

254646

123548

365684

548987

Input 2:

account number
0123456
0254646
0123548
0215684
0365684
0548987

Cheers,

Lance

[haroon_sa · Accepted solution]

Hey @lancegoh1

Try this expression in the formula tool. It may work. 

Substring([account number],1)

Take a look at my attached solution. 

[lancegoh1]

thank you!