Skip to main content

    Power BI

    Needs Votes

    Wildcard Search and Replace

    Vote (21) 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

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