Power BI

Needs Votes

Regular Expressions support in Power Query

Vote (993)

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 (79)

Ryan on 05 Jul 2020 23:57:59

RE: Regular Expressions support in Power Query

We need regex support! Not all IT admins allow users to install R so for us with no workaround, we need native regex!!

Vikas Singh on 05 Jul 2020 23:57:49

RE: Regular Expressions support in Power Query

Absolutely needed .

Frank Martin Petrat on 05 Jul 2020 23:57:41

RE: Regular Expressions support in Power Query

Regex are essential part of string manipulation. Should be a must for Power BI!

Power BI User on 05 Jul 2020 23:55:59

RE: Regular Expressions support in Power Query

regex is "THE" processing string tool. We need it!

Hong on 05 Jul 2020 23:50:59

RE: Regular Expressions support in Power Query

regex is definitly a MUST support in string processing! Absolutely needed.

Saur Dash on 05 Jul 2020 23:46:02

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.

ChrisA on 05 Jul 2020 23:45:23

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

Vitalii Martyniuk on 05 Jul 2020 23:45:21

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 !

Mats Bengtsson on 05 Jul 2020 23:34:46

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.

Power BI User on 05 Jul 2020 23:31:45

RE: Regular Expressions support in Power Query

I'm also shocked. It's a must have.

Merged Idea (2)