Just realized that this request is a duplication of the request in the following link: https://support.powerbi.com/forums/282523-bi-in-sql-vnext/suggestions/7260696-add-regular-expression-support-to-as-native-databa
The combined total is 30 votes. :)
Absolutely required for advanced cleansing and validating data in columns.
Regex.Replace, Regex.Match, Regex.Matches, Regex.IsMatch, Regex.Split
Could also be part of Text functions, e.g., Text.RegexReplace
258 votesunder review · 27 comments · Power BI Ideas » Data Preparation · Flag idea as inappropriate… · Admin →
I vote for adding this feature to Power Query via Table.FuzzyJoin and Table.NestedFuzzyJoin. Similar functionality to Excel's Fuzzy Lookup add-in.
Very important feature for more complex cleansing and validation