Regex support is one of functionality I miss most in PowerQuery. Doing multiple "substitute values" is awkward
Please provide this
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 !!
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/
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.
Having Regex withing PowerBI query editor will be an added advantage for data clean up and transformation
This would be a huge benefit and open so many benefits, if we are able to use regular expression in power query.
Enable regular expressions in conditional columns. Condition 'contains' is not sufficient in some cases.
Doing replaces on strings using REGEX would be so beneficial for data transformations.
So desperate for this. I have a complex regex for processing text which contains complex array data that I get from another data source. To replicate this using native M functions will be a nightmare. Report server doesn't allow R or Python scripts to be run, which would prevent auto refresh. Very frustrating. I would have thought it would be a basic function. Just integrate an existing REGEX library from python or somewhere into the M language, and have it iterate over one text cell at a time in a column.