Forum Discussion
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...
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 ?
One way would be to add a Suffix like "#" to your column on the transform tab, then replace Capital Fed#. When you are done you can simply replace # with null (leave the replace field empty).
If this solution works for you, please mark it as the solution. Kudos are appreciated too. Please let me know if not.
Regards,
Pat