Marco on 16 Jul 2015 14:17:27
We think regexp support will help the adoption of the Power Query tool in the most demanding use cases. Many thanks.
- Comments (76)
- Merged Idea (2)
RE: Regular Expressions support in Power Query
Is there any movement on this issue? Regex support would greatly improve adoption and use of Power Query/M Script, I know a number of potential users that find this a missing feature that results in far too many tedious and complex workarounds to solve data clean up and pattern matching issues that would be relatively simple with regex.
RE: Regular Expressions support in Power Query
This would be very, very helpful. Please implement!
Strongly supported this feature with 3 Votes!
RE: Regular Expressions support in Power Query
Totally agree!! I really miss this in Power Query
RE: Regular Expressions support in Power Query
example : remove {lf} from data but not {cr,lf}
RE: Regular Expressions support in Power Query
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. :)
RE: Regular Expressions support in Power Query
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