Forum Discussion

dlopez's avatar
dlopez
Advocate II
6 years ago
Solved

Replace entire column text value

Hi, I want to replace values in a text column but matching only entire values. That is, I want to match "CAPITAL FED" but not "CAPITAL FEDERAL" (it's Spanish 😉) I tried to use Transform > Replace...
Need Help
  • camargos88's avatar
    camargos88
    6 years ago

    dlopez ,

     

    Can you give some example of it? I tried here the option to Match entire cell contents, it worked.

    Have you tried clean/trim this column before the replace ?

     

Rickmaurinus's avatar
Rickmaurinus
Helper V
4 years ago

Hi,

 

I wrote some about the different between the two replacer functions. Replacer.ReplaceText also replaces substrings, whereas Replacer.ReplaceValue only matches the entire cell contents. If you like, I posted some screenshots in this article about the difference:

 

https://gorilla.bi/power-query/replace-values/#replacer-functions

 

Hope that helps!

 

Rick

 

--------------------------------------------------

@ me in replies or I'll lose your thread

 

Master Power Query M? -> https://powerquery.how

Read in-depth articles? -> BI Gorilla

Youtube Channel: BI Gorilla

 

If this post helps, then please consider accepting it as the solution to help other members find it more quickly.