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 (76)
- Merged Idea (2)
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
RE: Regular Expressions support in Power Query
I was considering dropping Alteryx and using M instead but with this limitation, I can't risk it,
RE: Regular Expressions support in Power Query
This is really sad to limit the language expressiveness like this. This is so simple to add from javascript or CLR. does not make any sense to reduce a data processing tool this way.
BTW: neither R ou web.page are a solution since they don't run native on Power BI Service.
RE: Regular Expressions support in Power Query
Regex are essential part of string manipulation. Should be a must for Power BI!