excel - Power Query - Replacing specific value based on another column

Question

As the title suggest, I'd like to replace the values of column x that contain in Text - Copy with "" (Blank/null)

I've tried the following but it does not seems to work to my ideal result.

= Table.ReplaceValue(#"Duplicated Column",each [x],"",Replacer.ReplaceValue,{"Text - Copy"})

This would be the ideal result that I'd like to yield

I've tried to use this as was given, but it doesnt yield the ideal result.

= Table.ReplaceValue(#"Duplicated Column",each [x],"",Replacer.ReplaceText,{"Text - Copy"})

question from:https://stackoverflow.com/questions/65623626/power-query-replacing-specific-value-based-on-another-column

Answer 1

Use Replacer.ReplaceText for replacer as function

= Table.ReplaceValue(#"Duplicated Column",each [x],"",Replacer.ReplaceText,{"Text - Copy"})