Create Power Query Text functions for REGEXTEST, REGEXEXTRACT, and REGEXREPLACE

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.