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 (73)
- Merged Idea (2)
RE: Regular Expressions support in Power Query
You can use the python plugin to do REGEX but it is tedious. I would much prefer to have it available natively in Power Query.
RE: Regular Expressions support in Power Query
Definitely need this basic function for any data manupulation. Can't believe it's not included.
RE: Regular Expressions support in Power Query
Regex support is one of functionality I miss most in PowerQuery. Doing multiple "substitute values" is awkward
RE: Regular Expressions support in Power Query
Please provide this
RE: Regular Expressions support in Power Query
Just wasted two days on filtering issues that would have been solved in 5 minutes with regular expressions. This is not only badly needed, it should be a basic feature of Power Query !!
RE: Regular Expressions support in Power Query
I've created Custom M Code function to let Power Query in Excel & Power BI able to use RegEx.
pls feel free to try my code. https://www.thepexcel.com/power-query-regex/
RE: Regular Expressions support in Power Query
It's 2021 and Microsoft ♥ Linux. Time for some Regular Expression ♥ for Power Query. Can't be that hard to add from the .Net libraries.
RE: Regular Expressions support in Power Query
Having Regex withing PowerBI query editor will be an added advantage for data clean up and transformation