Ability to use wildcards in power query transformation find section of replace values.

[bhobgood2]

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.

[zais_benedikt]

This is a must have!

[sd5]

either * ? or regex (better)

[radoshits]

This is a must have when trying to display/remove html characters

[admin171]

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, ....

[Steven_Myers]

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

[saeed_hessami]

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.