Extract Text Between Delimiters in Power Query M

Pulls out the text found between two delimiters, such as text inside parentheses.

Text TransformationsIntermediateextractdelimitersubstring

Power Query M code

let
    Source = YourTable,
    AddedExtract = Table.AddColumn(Source, "Extracted", each Text.BetweenDelimiters([ColumnName], "(", ")"), type text)
in
    AddedExtract

Notes

Returns an empty string for rows where the delimiters aren't found.

Requirements

A table with a text column containing the delimiters.

How to use this snippet

In Power BI Desktop, choose Transform data to open Power Query, then open the Advanced Editor on a query (or start from a blank query).
Paste the snippet and replace the placeholder names (tables, columns, file paths) with your own. Check the requirements above first.
Run it through the Power Query M Formatter to tidy the layout.

Related Power Query M snippets

More Power Query M resources

Browse all 145 snippets in the Power Query M Code Snippets, or search the library for something similar to Extract Text Between Delimiters.