Skip to main content

Power BI

Under Review

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

Vote (296) Share
bhobgood's profile image

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)
bhobgood's profile image Profile Picture

Saeed Hessami on 04 Jul 2022 20:47:23

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.

bhobgood's profile image Profile Picture

Steven Myers on 13 Jan 2022 20:38:45

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

bhobgood's profile image Profile Picture

Arie Saraf on 15 Aug 2020 08:41:05

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

bhobgood's profile image Profile Picture

Shai Radoshitzky on 06 Jul 2020 00:15:51

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

bhobgood's profile image Profile Picture

f on 06 Jul 2020 00:04:09

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

either * ? or regex (better)

bhobgood's profile image Profile Picture

Benny on 05 Jul 2020 23:48:51

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

This is a must have!

bhobgood's profile image Profile Picture

Andy on 05 Jul 2020 23:36:31

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.

bhobgood's profile image Profile Picture

iago on 05 Jul 2020 22:49:29

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

Regexp Replace, please!

bhobgood's profile image Profile Picture

Jeremiah on 05 Jul 2020 22:39:52

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

Yes Yes! Seriously! Actual Info Needed

Where's my replace ?

bhobgood's profile image Profile Picture

Power BI User on 05 Jul 2020 22:39:22

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',"")