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 (76)
- Merged Idea (2)
RE: Regular Expressions support in Power Query
Supporting PCRE2 would be a huge improvement of Power Query M capabilities.
RE: Regular Expressions support in Power Query
Regular expressions should be supported in Power Query, and generally in Dataflows in Data Factory part of Fabric. Regular expressions is defacto standard and open standard for string transformation. Data Factory is presented as transformation workload, but does not support any advanced text transformation function (except some simple excel-like function). Currently Data Factory is not possible use for transforming text data.
RE: Regular Expressions support in Power Query
Regular expressions should be supported in Power Query without resorting to hacks or external scripting tools.For starters, the developers behind Power BI/Power Query can implement a regular expression algorithm as described in the following link (NFA-based): https://deniskyashif.com/2019/02/17/implementing-a-regular-expression-engine/As Power Query currently stands, it is very limited in parsing text files, especially those not formatted with CSV, JSON, XML and simple character delimiters (spaces, tabs, colons, etc).
RE: Regular Expressions support in Power Query
I am surprised why this doesn't have enough votes yet!
RE: Regular Expressions support in Power Query
Having RegEx capability is essential for being able to extract/manipulate text efficiently. And available in public libraries so not a huge ask but massive capability increase for text handling
RE: Regular Expressions support in Power Query
Please make full RegEx support in Power Query. The current way of using it through (Web.Page function) performs very slow and does not support full regex functionality.
RE: Regular Expressions support in Power Query
Only 900+ upvotes in 8 years? Let's all take a moment to consider how many potential users took note of the lack of regexp and dropped the tool as a truly scalable option for SMBs.
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.