Forum Discussion

layheart's avatar
layheart
Regular Visitor
8 years ago
Solved

Extracting Text from different places within a text string

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!

  • jthomson's avatar
    jthomson
    8 years ago

    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

2 Replies

  • jthomson's avatar
    jthomson
    Solution Sage
    8 years ago

    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