Power BI
Under ReviewAbility to use wildcards in power query transformation find section of replace values.
bhobgood on 17 Mar 2015 08:12:03
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.
- Comments (14)
RE: Ability to use wildcards in power query transformation find section of replace values.
I propose those wildcards:
Sale !Sales for Sale but not Sales (! instead -)
"Sale" for exact whole word Sale
xxx* for starting with xxx
*xxx for ending with xxx
*xxx*yyy* for containing xxx and yyy (no matter in what order)
x?y for xay, xby, x1y, x2y, .... but not xaby
x#y for x1y, x2y, ....
x&y for xay, xby, ....
RE: Ability to use wildcards in power query transformation find section of replace values.
This is a must have when trying to display/remove html characters
RE: Ability to use wildcards in power query transformation find section of replace values.
either * ? or regex (better)
RE: Ability to use wildcards in power query transformation find section of replace values.
This is a must have!
RE: Ability to use wildcards in power query transformation find section of replace values.
I would like the ability to select **/**/** in a Power query column, replacing with blank.
RE: Ability to use wildcards in power query transformation find section of replace values.
Regexp Replace, please!
RE: Ability to use wildcards in power query transformation find section of replace values.
Yes Yes! Seriously! Actual Info Needed
Where's my replace ?
RE: Ability to use wildcards in power query transformation find section of replace values.
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',"")
RE: Ability to use wildcards in power query transformation find section of replace values.
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.
RE: Ability to use wildcards in power query transformation find section of replace values.
this is really needed!