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 (41)
RE: Regular Expressions support in Power Query
Another request here for REGEX support. While a huge amount is possiblewith existing M Code and the excelling Power Query UI, I've encountered a situation where I absolutely need to use REGEX to extract certain patterns from a field.
RE: Regular Expressions support in Power Query
I need to use regex to parse a string representation into a lists of values. Please add this! Quite common to convert unstructured data into data that can be reported on.
~400 votes are here now for regex support!!
RE: Regular Expressions support in Power Query
Nothing has been going on for almost four years, when do you implement RegEx in Power Query, Power BI?
Don't delay !
RE: Regular Expressions support in Power Query
The lack of built in Regex is a great shortcoming in Power Bi. Fixed in SQL server long time ago, but lacking as soon as one uses Power Bi directly without SQL server as middle man.
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
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.