Skip to main content

    Power BI

    New

    Wildcard Search and Replace

    Vote (11) Share
    's profile image

    on 25 Aug 2017 20:34:28

    In plain excel you can use wildcard for Search and Replace. Please include wildcard use in Power Query, and other Query editors.

    Comments (1)
    's profile image Profile Picture

    d41fd652 3cc7-ea11-a812-000d3a9b112e on 15 Aug 2020 08:44:38

    RE: Wildcard Search and Replace

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