Hi all,
I am trying to replicate this excel formula in Alteryx: Left(Fieldname; Len(Fieldname) - Search(".";Fieldname)).
I use this formula: left([Fieldname],Length([Fieldname])-FindString([Fieldname],".")) but it does not work.
Anyone can help me?
Thank you
Claudia
Hi Claudia
As far as I know, the Left expression only works with a string field and the number of characters to take - I don't think you can use another field as the number of characters.
Is there another way you can tell the expression how many characters to take?
If you want to take the strings before the "." this should work:
left([Field1],Length([Field1])-(FindString([Field1],".")-1))
I just fin the easy way : Left([Field], ToNumber(FindString([Field], "-")))