Skip to main content

Power BI

Needs Votes

Regular Expressions support in Power Query

Vote (993) 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)