LEFT FORMULA

Question

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

ArturoJGarciaJmz · Answer

I just fin the easy way : Left([Field], ToNumber(FindString([Field], "-")))

dougperez · Answer

If you want to take the strings before the "." this should work:

left([Field1],Length([Field1])-(FindString([Field1],".")-1))

NicoleDuhamel · Answer

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?