Converting Nested Excel Text Function to Power Query (M)

[BobbyG]

Hi,

I'm trying to extract text of various lengths within string based on the position of certain operators within a string. 

The current excel formula i'm using to do this is as follows: =TRIM(MID(A2,FIND("Text1",A2)+11,IFERROR(FIND("|",A2,FIND("Text1",A2)),LEN(A2))-FIND("Text1",A2)-IF(OR(FIND("Text1",A2)=1,LEN(A2)-LEN(SUBSTITUTE(A2,"|",""))>=2),11,9)))

Trying to recreate this using various Text functions (Range, PositionOf, etc.) but having some trouble, espescially when it comes to the last if or section

[Interkoubess]

Hi @BobbyG,

Could you please share dummy data ( some examples ) and I will make a try.

Ninter