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 ...
  • jthomson's avatar
    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