Foundation Documentation and SupportV6 User Manual The Fix ToolHow do I Find and Replace within a Column? (Version 1.1)

How do I Find and Replace within a Column? (Version 1.1)

1. Right click on the header to open the Header Menu.

Right click on the header to open the Header Menu.

2. Choose Find & Replace.

TMMData - my.tmmlog.in - Google Chrome

3. Choose what it's to find and what it's to replace then click transform.

For this example, we will type:

1. "Big"

2. "BIG"

3. Then we will select the "TRANSFORM" button...

TMMData - my.tmmlog.in - Google Chrome

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).  

TMMData - my.tmmlog.in - Google Chrome