Skip to main content

Power BI

Needs Votes

Regular Expressions support in Power Query

Vote (622) Share
Marco's profile image

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)
Marco's profile image Profile Picture

866b4d37 64db-4902-9ce6-2bf2f590838a on 05 Jul 2020 22:57:55

RE: Regular Expressions support in Power Query

Wow. What's a dev gotta do to get regex support in powerBI? Beg? (I have no ego here)

Marco's profile image Profile Picture

9d3a31cb 6cad-47dc-aba8-7382e8e8985d on 05 Jul 2020 22:52:26

RE: Regular Expressions support in Power Query

This would be very powerful, especially when combined with filtering data based on regular expressions.

Marco's profile image Profile Picture

c4cc1db0 5f97-4d41-afcc-c385eb2b3b77 on 05 Jul 2020 22:50:49

RE: Regular Expressions support in Power Query

Why is this taking this long to implement?

Marco's profile image Profile Picture

53ae2ede 19df-4ce5-8c65-cccd73ac3d6b on 05 Jul 2020 22:47:18

RE: Regular Expressions support in Power Query

I'd like create tables based on regex ran against a log file.

Marco's profile image Profile Picture

659d1b6c 489f-417f-9b90-245053264d63 on 05 Jul 2020 22:46:32

RE: Regular Expressions support in Power Query

I agree, please put in your backlog

Marco's profile image Profile Picture

bc401a8d 5941-4270-a246-a57f6b2d2b68 on 05 Jul 2020 22:41:35

RE: Regular Expressions support in Power Query

Is there any movement on this issue? Regex support would greatly improve adoption and use of Power Query/M Script, I know a number of potential users that find this a missing feature that results in far too many tedious and complex workarounds to solve data clean up and pattern matching issues that would be relatively simple with regex.

Marco's profile image Profile Picture

11db2414 567a-46ab-89aa-580c2d594188 on 05 Jul 2020 22:41:27

RE: Regular Expressions support in Power Query

This would be very, very helpful. Please implement!
Strongly supported this feature with 3 Votes!

Marco's profile image Profile Picture

c1c2a444 40a6-4ffd-b293-42451e02fcd3 on 05 Jul 2020 22:37:00

RE: Regular Expressions support in Power Query

Totally agree!! I really miss this in Power Query

Marco's profile image Profile Picture

983620d6 ce81-4e12-977d-01051a6af232 on 05 Jul 2020 22:20:29

RE: Regular Expressions support in Power Query

example : remove {lf} from data but not {cr,lf}

Marco's profile image Profile Picture

0af38c74 2dca-4e8f-ad3e-e78b6c4c88ec on 05 Jul 2020 22:03:58

RE: Regular Expressions support in Power Query

Just realized that this request is a duplication of the request in the following link: https://support.powerbi.com/forums/282523-bi-in-sql-vnext/suggestions/7260696-add-regular-expression-support-to-as-native-databa

The combined total is 30 votes. :)