Table editor - Metasys - LIT-12013963 - Software Application - Mass Changes Tool - 3.0.0.x

Mass Changes Tool (MCT) Help
Product
Building Automation Systems > Configuration and Programming Tools > Mass Changes Tool
Document number
LIT-12013963
Version
3.0.0.x
Revision date
2022-06-24

Menu Selection: View > Table Editor

Use the table editor to quickly make changes to the values contained in a single column of the grid table. Table 1 describes the fields of the table editor:
Table 1. Table editor settings
Field Description
Column Selection Select the column that contains the values you want to modify.
Action Select the type of action you want use to modify the values of a column.
Action Range Select all cells to modify all the values in a column, . To modify the values of a select number of cells in a column, highlight the cells in the gird table, then open the table editor window, and select the selected cells option.
Find Enter the value you want to locate.
Replace Enter the new value you want to replace.
Append Enter the value you want to append to the existing value.
Table 2 describes the actions available with the Table Editor:
Table 2. Table editor actions
Action Description
Find and Replace Locates an existing value and replaces it with a new value.
Replace All Replaces all the values in the cells you select.
Default Value Replaces an existing value with the default value. Cells with default values appear green in the grid table.
Find and Append Before Locates an existing value and appends text before the value.
Append Before Appends text before all the values in the cells you select.
Find and Append After Locates an existing value and appends text after the value.
Append After Appends text after all the values in the cells you select.
First Char of Words Uppercase Changes the first character of all the words in selected cells to uppercase.
First Char of String Uppercase Changes the first character of the first word in selected cells to uppercase.
All Uppercase Changes all characters in selected cells to uppercase.
All Lowercase Changes all characters in selected cells to lowercase.
Fill Series Locates an existing value, replaces it with a new value, and creates a number series based on the rules specified. The placeholder for the number is the # character.
Add Offset Increments or decrements the values by the specified offset.
Find and Replace (Regular Expression) Locates an existing value and replaces it with a new value, applying regular expressions.