Specifying Replacement Values for Ranges of Data Values

You can specify values for ranges of data values.

  1. In Microsoft Notepad or another text editor, create a text file.
  2. In the text file, type the following line: 
    TRAPEZE MAPMAKER LOOKUP TABLE BEGIN
  3. Optional: To specify values for numeric ranges of data, type the following line between the lines entered in step 2. 
    COMPARE NUM
  4. For each range of values in the import file for which you want to specify a replacement value in the database, type the following line: 
    importedRangeValueStart;importedRangeValueEnd;replacementValue
    • importedRangeValueStart is the first value in the range of imported field values to replace with the replacementValue in the database.
    • importedRangeValueEnd is the last value in the range of imported field values to replace with the replacementValue in the database.
    • replacementValue is the data value for replacing field data values within the specified range of values.
  5. To type a comment in the file, on a separate line, type // (two slashes) followed by the comment text.
    An example of a sample replacement values table for ranges of data values:
    TRAPEZE MAPMAKER LOOKUP TABLE COMPARE NUM
//map 10000 to 19999 to A10 10000;19999;A10
20000;29999;A20
30000;39999;A30;