Convert excel formula to Alteryx formula

Question

Hi there,

Im trying to use the formula I used on excel, on a alteryx workflow, but the language is somewhat different.

how can I translate this formula, to alteryx language?

=IF(LEN(TEXT(NUMBERVALUE(MID(Q2,SEARCH("4",Q2),7),"."),"0"))=7,NUMBERVALUE(MID(Q2,SEARCH("4",Q2),7)),"")

thankyou all!

RolandSchubert · Accepted Answer

Hi @caiovidal22 ,

I think, it should be:

IIF(Length(ToString(ToNumber(Substring([Field1], FindString([Field1], '4'), 7), 0, 1, '.'))) = 7, ToNumber(Substring([Field1], FindString([Field1], '4'), 7), 0, 1, '.'),'')

I've attached a workflow, so you can better identify the "translation".

Best

Roland

CharlieS · Accepted Answer

Here's a list of corresponding functions:

Excel -> Alteryx

LEN( -> Length(

TEXT( -> ToString(

NUMBERVALUE( -> ToNumber(

MID( -> SubString(

SEARCH( -> FindString(

Looks like @RolandSchubert nailed it.