Skip to main content

    Power BI

    Under Review

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

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

    fc0ef05a 0620-4b3c-8565-83db7e9f83c6 on 05 Jul 2020 22:33:31

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

    Must have feature!!

    bhobgood's profile image Profile Picture

    bff9b5e5 a44f-4500-a217-3e4d25385c90 on 05 Jul 2020 22:31:52

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

    Would prefer Regex

    bhobgood's profile image Profile Picture

    9d2cff81 598e-4e22-8498-0de343092c41 on 05 Jul 2020 22:27:04

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

    Must have feature!!

    bhobgood's profile image Profile Picture

    0eb45425 7081-429f-ab22-a92e0ce184f1 on 05 Jul 2020 22:21:08

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

    Must have feature!!