Enable Regex to increase the power of powerquery. Some function such as split column and extract are good but could be great if custom regex could be used to pattern match more effectively.
We desperately need the REGEX functions added to Power Query. Excel has already had these added in 2024 (REGEXTEST, REGEXEXTRACT, and REGEXREPLACE). See for reference Excel REGEX blog.
Yes, Python can be used for this, but this requires a Personal Gateway.
Yes, the javascript hack can be used for Power BI Desktop, but this does not refresh in the Power BI service.
This is a basic function that has also been applied in Power Apps Power Fx.
