Foundation Documentation and SupportUser The Prep ToolHow do I Find and Replace within a Column?

How do I Find and Replace within a Column?

Right-click on a Header (to open the Header Menu).

Minitab Connect - - Google Chrome

Select Find & Replace.

Minitab Connect - - Google Chrome

Choose what the Filter is to Find and also what the Filter is to Replace:

    1. We typed "Internet Explorer."

    2. We typed "I.E."

    3. We selected the Transform button.

Minitab Connect - - Google Chrome

Congratulations, the values have been replaced!  Here is a glimpse of what changes took place.  


Minitab Connect - - Google Chrome

NOTE: This Find and Replace feature does NOT permanently change what is in the database.  It simply creates a Prep for your view.  If you need to change the actual values inside the database, then you would need to use a Data Process.