Spreadsheet Search/Replace Feature

From mtab wikisupport
Revision as of 12:27, 18 July 2013 by Mtabadmin (Talk | contribs)

Jump to: navigation, search
mTAB gives users the option to search for a text string in almost every window with text in it. Within the mTAB spreadsheet environment, we have an extremely useful Search/Replace feature that allows users to make custom changes to any text of their choosing. To use this feature, go to the Appearance menu and locate the Replace button in the Edit section.
Spreadsheet spreadsheet-search-replace-feature replace-button.jpg
After running a tab, let’s imagine we realize that one of the companies has changed their name. We want to find all occurrences of the old company name “Brand B”, and replace it with the new company name “Brand B, Inc.”. The example below displays the settings used, before clicking on the “Replace All” button to execute the change.
Spreadsheet spreadsheet-search-replace-feature replace-with.jpg
The changes made will remain intact throughout other views in mTAB, based off the spreadsheet view, like the Top N Report .
Spreadsheet spreadsheet-search-replace-feature topN-view.jpg
This feature also makes it easy for users to select standard text strings found within the mTAB spreadsheet and to replace them. There is a drop down menu under the Find What box that lists different mTAB standard text strings like Mean/Weighted Average and Weighted Sample Total Count that can also be replaced.
Spreadsheet spreadsheet-search-replace-feature find-what.jpg