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 ?

     

camargos88's avatar
camargos88
Community Champion
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 ?