Using the Table Editor - Metasys - LIT-12011931 - Supervisory Device - Network Engine - 10

VMD Generator Express Application Note

Brand
Metasys
Product name
Network Engine
Document type
Application Note
Technical Bulletin
Document number
LIT-12011931
Version
10
Revision date
2017-06-01
Language
English

About this task

You can manipulate data in the Points table by using the Table Editor. For example, you can perform a global search and replace on any text that appears in any column of the Points table.

Procedure

  1. Select View > Table Editor, or click the Table Editor toolbar button (Figure 1).
    Figure 1. Table Editor Toolbar Icon

    The Table Editor window appears (Figure 2).

    Figure 2. Table Editor

  2. In the Column Selection drop-down box, select which column you want to use for the action. You can select from the following columns: Unique ID, Description, Units, States Text, Display Precision, Function, Address, Data Type, Mathematical Function, Slope (m), Intercept (q), and Comment. The Action and Action Range fields pre-populate for you.
  3. In the Action drop-down box, select Find and Replace or Replace All.
  4. In the Action Range drop-down box, select Selected Cells or All Cells.
  5. In the Find field, make an appropriate entry depending on what type of data you are looking for. Either type in the value or select it from the drop-down box.
  6. In the Replace field, make an appropriate entry depending on what type of data you are replacing. Either type in the value or select it from the drop-down box.
  7. In the Append field, make an appropriate entry if one is required.
  8. Click Execute. The changes are made to the Points table, and a Results Report appears to summarize what was changed (Figure 3).
    Figure 3. Example of Results Report