Skip to main content

    Power BI

    Needs Votes

    Regular Expressions support in Power Query

    Vote (622) Share
    Marco's profile image

    Marco on 16 Jul 2015 14:17:27

    We think regexp support will help the adoption of the Power Query tool in the most demanding use cases. Many thanks.

    Comments (41)
    Marco's profile image Profile Picture

    0af38c74 2dca-4e8f-ad3e-e78b6c4c88ec on 05 Jul 2020 22:03:47

    RE: Regular Expressions support in Power Query

    Absolutely required for advanced cleansing and validating data in columns.

    Regex.Replace, Regex.Match, Regex.Matches, Regex.IsMatch, Regex.Split

    Could also be part of Text functions, e.g., Text.RegexReplace