Extracting Text from different places within a text string

[layheart]

Hi,

I am trying to extract the text between two specific texts within a string.  I have a DESC_TXT column that has many different line items.

Example of one of the line items:

COMP: Pipe Install, DIA: 30, SZ2: 0, SPEC: 6CS19, MATL: CS, WTHK: 0.750", LOCN: Underground, FAB: Shop, DESC: FLG-WN , CS A694-F70 , CL900 , RF , 17.48mm (0.688") , SP-44 WT, SP-44, LINENO: 1HC-21006, ROWID: [715]

.. I want to be able to extract only the CS that between MATL: and , WTHK:

I am having trouble with the dax formula.

Thanks for your help!

[v-chuncz-msft]

@layheart,

By the way, you may use SEARCH Function in DAX.

[jthomson · Accepted solution]

It's probably possible within DAX but I'd personally split the column in Power Query, using MATL: and , WTHK: as delimiters, which should leave you with a column that contains only the bits in the middle you want