How do I Find and Replace within a Column?
1. Right click on the header to open the Header Menu.
2. Choose Find & Replace.
3. Choose what it's to find and what it's to replace then click transform.
4. Congratulations, the values have been replaced.
This feature doesn't permanently change what is in the DB, it creates a fix for your view. If you need to change the actual values inside the DB then you need to use a Data Process.