Remove a list of words from a string

[Brian_M]

Hi

@ImkeF seeing that you aced the question about removing characters, do you know an efficient way to remove a list of words from a string?

I know this doesn't work since Text.Remove takes a list of characters, not a list of strings.

= Text.Remove ( "PeterPaulMary", { "Peter","Mary" } )

I can do Text.Replace but that will only do one word at a time.

Thanks!

[ImkeF · Accepted solution]

Please try if this works: http://www.thebiccountant.com/2016/05/22/multiple-replacements-in-power-bi-and-power-query/ & report back, as I haven't tried it out myself with blanks.

Just leave the column "ReplaceWith" blank.

[Brian_M]

Works a treat, thank you 🙂