Formula is not working ( Left, Len)

[Maheshp]

Hi Team,

I want to apply the formula =LEFT(AC12,LEN(AC12)-6) in Alteryx but it is not working, could you please help us to set the formula.

Raw Data	Required data with the help of formula.
VISA0012251968231002	VISA0012251968

Regards,

Mahesh

[Kanishkas5301]

Hi Mahesh!

The formula seems to be working for me. Can you share the workflow you are using? It might be easier to debug from that what's the exact issue. 

Thanks!

[kunalswami]

please refer to suggested workflow