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
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.
RE: Regular Expressions support in Power Query
Why is this taking this long to implement?
RE: Regular Expressions support in Power Query
I'd like create tables based on regex ran against a log file.
RE: Regular Expressions support in Power Query
I agree, please put in your backlog