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)
- Merged Idea (2)
RE: Regular Expressions support in Power Query
Very surprising this thread exists. Better late than never.
RE: Regular Expressions support in Power Query
Regex in Advanced Filters is a must. Current text filtering options are not so good.
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.
RE: Regular Expressions support in Power Query
I assumed it would be available.
RE: Regular Expressions support in Power Query
This is absolutely critical for the functionality of Power Query, especially in Excel.
RE: Regular Expressions support in Power Query
Regex is a good option to add in M environnement
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.
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
RE: Regular Expressions support in Power Query
I can't believe that this isn't part of Power Query :( so sad.
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