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.
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 )
