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.
In the transformation area of replace values it would be nice to be able to use a wildcard in the value to replace field. For example we have transaction descriptions like... Placement [EB-12375596] and it would be great to be able to enter something like... Placement% to capture all of these. I've got several work-arounds but this would be a great feature for those who don't know SQL.
- Must have feature!!
- Must have feature!!
- Would prefer Regex
- Must have feature!!
- this is really needed!
- Yes! We have data entry clerks that have been posting emails directly into our software. When we run reports on that information we get lengthy garbage surrounding the needed information because formatting code fills it up. Every blank line in an email equals 175 characters of garbage in our database. Wildcard is needed as the surrounding formatting code is highly dynamic. Need Text.Replace('Table',"<*>","") or Text.Remove('Table',"<*>")
- Yes Yes! Seriously!Actual Info Needed Where's my replace <*>?
- Ditto! Would be nice to have. I now have to add several steps to cover several different "literal" scenarios, whereas a wildcard would reduce it down to one step. In addition it would be nice if you could search for values only or text only, or a combination. Something like ".0#" would look for a values ".00", ".01", ".02"... ".09" but NOT ".0a" or any other non-digit string, and replace it with the value provided. (We would need a char for "any values".) Or if you wanted to replace text strings use "?" for single char, and * for any characters.
- Regexp Replace, please!
- I would like the ability to select **/**/** in a Power query column, replacing with blank.
