Help convert Excel formula to use in Power Query

[Anonymous]

Howdy from Texas!

I am trying to do a custom column in Power Query using the following excel formula:

=IF(F2="DORCORE",LEFT(A2,FIND("-C",A2)-1),IF(F2="SURPLUS",LEFT(A2,FIND("-S",A2)-1),IF(F2="CORES",LEFT(A2,FIND("-C",A2)-1),IF(F2="SURPLUS-Z",LEFT(A2,FIND("-SZ",A2)-1),IF(F2="ENGCORE",LEFT(A2,FIND("-C",A2)-1),IF(F2="FORD-S",LEFT(A2,FIND("-F",A2)-1),IF(F2="FORD-SZ",LEFT(A2,FIND("-FZ",A2)-1),IF(F2="BLEMISHED",LEFT(A2,FIND("-Z",A2)-1),A2))))))))

Is it possible to convert this in Power Query and if so, can anyone help me with the code?

Many thanks!!!

[Greg_Deckler · Accepted solution]

@Anonymous Power Query if syntax is:

if <condition> then <result> else <result>

You can nest these as much as you want. The equivalent to LEFT is Text.Start function. The equivalent of FIND function is Text.Position function.