LEFT FORMULA

[ClaudiaDib]

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

[NicoleDuhamel]

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?

[dougperez]

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

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

[ArturoJGarciaJmz]

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