Use the Character Mapper component window to define mapping rules for data that passes between the IN-port and OUT-port.
The Character Mapper component window includes the:
Current Input Record pane, which displays the columns, rows, and content for the record currently at the IN-port.
The Current Output Record pane, which displays the columns, rows, and content for the current record as it appears to the OUT-port.
The Mapping definition pane, which includes a From column and a To column.
Creating new mapping definitions
Click the Insert Mapping icon on the toolbar, or right-click anywhere on the Mapping Definition pane, and select Insert Mapping. A new row is inserted for the new mapping definition.
Enter the character combination you want to replace in the From column and the value with which you want to replace it in the To column. Character Mapper applies the rule, and displays the results in the Current Output Record pane.
To edit the record currently displayed in the Current Input Record pane, click a row in the Current Input Port Content pane and make changes. The values in the Current Output Record pane and the selected row in the Current Outport Port pane are also updated.
To delete a mapping definition, right-click the mapping definition, and select Remove Mapping. The selected mapping definition is deleted.
To change the order of the mapping definitions, select the Move row up and Move row down icons on the toolbar.
Character Mapper applies the mapping, and updates the Output results as soon as you write the rule. Click the Enable auto refresh of output values icon on the toolbar to toggle this kind of automatic synchronization.
Character Mapper applies mappings to all columns and
all rows. If you want to exclude columns from a character mapping,
click Exclude in the Properties window, and select the columns you
want to exclude.
Character mapping definitions can be saved to a file, allowing to reuse them in other projects. To save the character mappings to a definition file, and reuse them in other projects:
Click Export character mapping and Import character mapping icons on the toolbar. See Exporting mapping definitions and Importing mapping definitions for more information.
On the Character Mapper component window, click the Export character mapping icon on the toolbar.
Provide a file name and click Save.
Character Mapper saves the file without an extension.
In the Character Mapper component window, click the Import character mapping icon on the toolbar.
Select the file you want to import and click Open.
