How to use "replace and left" function together for formula tool in Alteryx?

[cloh021]

Hi,

I have a field column [ID]  which is MY1234567890123456789, I manage to use a formula tool  Left([ID],10) to remain MY12345678, however if i wanted to remove MY, may i know what formula i can use together with Left function for formula tool?

Thanks heaps!

[binuacs · Accepted solution]

@cloh021 you can use substring function 

String Functions | Alteryx Help

[cloh021]

Thanks Alot!! It works!