Enabling Python and Regular Expressions in Power Query in Excel

pq-regex-example-url.txt

Here's an example of how this pyscript app works in the browser:

https://owenprice.pyscriptapps.com/pq-regex/latest/?txt=abc123def456&pattern=%5Cd%2B

To clone the project and modify, create an account on pyscript.com and clone this project:
https://pyscript.com/@owenprice/pq-regex/

pq-regex-example-usage.m

let
    Source = RegexExtract("abc123def456", "\d+")
in
    Source

pq-regex-function.m

let
    RegexExtract = (txt as text, pattern as text) =>
    let
        baseUrl = "https://owenprice.pyscriptapps.com/pq-regex/latest/",
        url     = baseUrl & "?txt=" &
                  Uri.EscapeDataString(txt) &
                  "&pattern=" &
                  Uri.EscapeDataString(pattern),

        html    = Web.BrowserContents(url, [WaitFor=[Timeout=#duration(0, 0, 1, 0)]]),

        parsed  = Html.Table(
                    html,
                    {{"Match", "div#output *"}}
                  ),

        matches = List.Select(
                    parsed[Match],
                    each _ <> "" and _ <> "No matches" and _ <> "Invalid regex pattern"
                  )
    in
        matches
in
    RegexExtract