758
We think regexp support will help the adoption of the Power Query tool in the most demanding use cases. Many thanks.
STATUS DETAILS
Needs Votes

Comments

M

Regex support is one of functionality I miss most in PowerQuery. Doing multiple "substitute values" is awkward

M

Please provide this

M

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 !!

M

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/

M

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.

M

Having Regex withing PowerBI query editor will be an added advantage for data clean up and transformation

M

This would be a huge benefit and open so many benefits, if we are able to use regular expression in power query.

M

Enable regular expressions in conditional columns. Condition 'contains' is not sufficient in some cases.

M

Doing replaces on strings using REGEX would be so beneficial for data transformations.

M

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.