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)
- Merged Idea (2)
RE: Regular Expressions support in Power Query
8 years and counting!!
RE: Regular Expressions support in Power Query
Actually, I think the upvote just took, but the latency was very high.
RE: Regular Expressions support in Power Query
Why doesn't the vote counter seem to increment when I click the upvote button?If there is some kind of latency or delay, that delay is huge.
RE: Regular Expressions support in Power Query
Good grief, this idea was originally posted SEVEN years ago! And still it's not taken up by the PowerBI team?
RE: Regular Expressions support in Power Query
It gets even worse when ETL runs in PBI data flows. Here you can't use the Python or R workarounds because they are not supported in the PBI service.Please add Regex to dataflows as well!
RE: Regular Expressions support in Power Query
Assuming MS have written PowerQuery in .NET, it would be easy passthru tech to enable regex ... such a quick win, it's surprising it hasn't already been added really.
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