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 (16)
RE: Ability to use wildcards in power query transformation find section of replace values.
I am surprised to find that the use of wild card is not supported in power query transformation replace function. This is a fundamental feature. Microsoft please implement at your earliest practical.
RE: Ability to use wildcards in power query transformation find section of replace values.
This would be very helpful, We have users that use the Dynamics BC product and are use to REGEX.There is no easy way to filter for '6*|7*|96*" in Power BI
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',"")