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 ?

     

dax's avatar
dax
Community Support
6 years ago

Hi dlopez , 

Based on this document, I think when columns have numeric or other types, it will use replacer.replacevalue. In addition, which part don't work? If possible, could you please inform me more detailed information(such as your expected output and your sample data (by OneDrive for Business))? Then I will help you more correctly.

Please do mask sensitive data before uploading.

Thanks for your understanding and support.
Best Regards,
Zoe Zhi

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