Regular expressions

Fabric Data Warehouse will introduce T-SQL functions for pattern matching, text extraction, and transformation using regular expressions. These capabilities will make it easier to validate, search, and manipulate text data directly within your queries.New functions include:* REGEXP_LIKE - Returns a Boolean indicating if the text matches the regex pattern.* REGEXP_REPLACE - Replaces occurrences of a regex pattern with a specified string.* REGEXP_SUBSTR - Extracts parts of a string based on a regex pattern, including Nth occurrence.* REGEXP_INSTR - Returns the position (start or end) of a matched substring.* REGEXP_COUNT - Counts how many times a regex pattern occurs in a string.* REGEXP_MATCHES - Returns a table of captured substrings matching the regex pattern.* REGEXP_SPLIT_TO_TABLE - Splits a string into rows using a regex delimiter.