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.
It would be super useful to be able to create a conditional column in power query using a search function that contains wildcards.
Example:
I want to sort complaints about coffee. Some people write the coffee is really bad, others write the coffee is bad, others write the coffee is good. I would like to be able to search "Coffee*bad" to create a conditional column based solely off of people who say coffee and bad, but not the people who say coffee * good.
It has many uses and of course can be done with RegEx in VBA, but sometimes its completely impractical if using powerbi and need refreshing reports without running VB scripts.
- Status added:New
