Skip to main content

    Power BI

    Needs Votes

    Regular Expressions support in Power Query

    Vote (989) 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 (79)
    Marco's profile image Profile Picture

    Isaac Peterson on 11 Jan 2021 04:25:47

    RE: Regular Expressions support in Power Query

    Very surprising this thread exists. Better late than never.

    Marco's profile image Profile Picture

    Jean-Francois Monfette on 14 Dec 2020 20:45:12

    RE: Regular Expressions support in Power Query

    Regex in Advanced Filters is a must. Current text filtering options are not so good.

    Marco's profile image Profile Picture

    Nicholas Archer on 18 Nov 2020 06:14:25

    RE: Regular Expressions support in Power Query

    This is a mandatory feature. The alternatives and workarounds are unacceptable and I feel we are severely limited by its absence.

    Marco's profile image Profile Picture

    Luke Brennan on 18 Nov 2020 01:42:40

    RE: Regular Expressions support in Power Query

    I assumed it would be available.

    Marco's profile image Profile Picture

    Thomas Carruthers on 07 Oct 2020 18:14:14

    RE: Regular Expressions support in Power Query

    This is absolutely critical for the functionality of Power Query, especially in Excel.

    Marco's profile image Profile Picture

    mourad on 10 Jul 2020 17:20:37

    RE: Regular Expressions support in Power Query

    Regex is a good option to add in M environnement

    Marco's profile image Profile Picture

    Kate on 06 Jul 2020 00:17:55

    RE: Regular Expressions support in Power Query

    Yet another vote up for having RegExp capabilities. We need to use it in a switch statement. Its going to be a real pain without this.

    Marco's profile image Profile Picture

    Mark Domansky on 06 Jul 2020 00:17:26

    RE: Regular Expressions support in Power Query

    This is absolutely necessary. In the mean time, for those who actually need a solution and can use Python, I've figured out a workaround: https://gist.github.com/markdomansky/06776213a5abbcedbbd9f148cce4b494

    Marco's profile image Profile Picture

    Pablo Fernandes on 06 Jul 2020 00:16:21

    RE: Regular Expressions support in Power Query

    I can't believe that this isn't part of Power Query :( so sad.

    Marco's profile image Profile Picture

    Power BI User on 06 Jul 2020 00:14:04

    RE: Regular Expressions support in Power Query

    Very surprised to discover regexp is not native to Power Query, can't really call this an ETL tool if regexp is not implemented

    Merged Idea (2)