Regex in PowerQuery

[SaythJWRenshaw]

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.

[Martin_Kmec]

same idea here: https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/8892295-regular-expressions-support-in-power-query

[VEGA_Y_J_CHEN]

Strongly support on this initiative! PowerQuery is the most suitable tookit from PowerPlatform while considering some needs of text extraction in Regex way. This proposal is aligned with design of Making ETL(Extract/ Transform / Load) within PowerQuery. What's more, I think it can be a puzzle to complete the Product roadmap while Power Platform building more advanced features vs. competitors.

[drother]

Regex is a critical tool for manipulating data. I strongly support regex in PowerQueryl

[DavidPearce]

I was given by my AI Chatbot the use of two functions that don't exist, Text.Matches and Text.Like - I was *really* excited since they seemed logical. Hard to believe regex isn't native. Being an analyst I have no experience in trying to use a personal gateway to a Python script... Table.AddColumn( #"Trimmed Text", "Mailrun", each if Text.Matches([Sub Account], "^\d{6}-\d{3}$") then [Sub Account] else if Text.Matches([Sub Account], "^\d{6}-\d{3}-\d$") then [Sub Account] else null ) then = Table.AddColumn( #"Trimmed Text", "Mailrun", each if Text.Like([Sub Account], "??????-???") then [Sub Account] else if Text.Like([Sub Account], "??????-???-#") then [Sub Account] else null )