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
This is completely necessary !!! I need to replace a column that "contains" certain data (not the complete occurrence) this is so basic!! please implement it ASAP!! this has been here for so long !! 3 years and you can't put it ?!!
RE: Regular Expressions support in Power Query
Microsoft please we need RegEx natively in Power Query. The cheapest text editors have it in one form or another, it should be available in your flagship BI product.
RE: Regular Expressions support in Power Query
Very important ideia, I use already regex in Tableau Desktop and Python. It should have this function in Power BI.
RE: Regular Expressions support in Power Query
This is should be helpful compared to other tools (like Dremio or any other open source tools)
RE: Regular Expressions support in Power Query
Agreed. I will use Python instead of Power Query or M because of this. This is a crucial element to data cleanup and I need this in virtually all of my data files. Very disappointed that M does not support this.
RE: Regular Expressions support in Power Query
You can use R to pre-filter using regexp but I am tired of workarounds, especially if cumbersome.
Looking at the recent PBI releases, it seems most changes were made on the front-end rather than more functions in the query/filter engine. Too bad. Note that Tableau, Qlik and Sptfire have regexp implemented for quite some time.
RE: Regular Expressions support in Power Query
You can use R to pre-filter using regexp but I am tired of workarounds, especially if cumbersome.
Looking at the recent PBI releases, it seems most changes were made on the front-end rather than more functions in the query/filter engine. Too bad. Note that Tableau, Qlik and Spotfire have regexp implemented for quite some time.
RE: Regular Expressions support in Power Query
Wow. What's a dev gotta do to get regex support in powerBI? Beg? (I have no ego here)
RE: Regular Expressions support in Power Query
Yes please. To be able to do "Advanced Filtering" and selecting "Starts with" from the drop down then allow [a-zA-Z] would be amazing please!
RE: Regular Expressions support in Power Query
This would be very powerful, especially when combined with filtering data based on regular expressions.