How do I Find and Replace within a Column? (Version 1.1)
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.
For this example, we will type:
3. Then we will select the "TRANSFORM" button...
4. Congratulations, the values have been replaced.
This feature does NOT permanently change what is in the DB... it simply 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.
Here is a snapshot of what changes took place (highlighted in orange to make them more obvious).