Updating an Existing Name/Value Section Format

Double-click the Data Exchanger component icon .

The Data Exchanger Component Editor appears.

From the Data Exchanger Component Editor, select the data that you want to update from the Data Source.

Right-click the highlighted data, and select Edit Section details.

The Edit Section Format dialog box appears.

Edit the details used to construct the format, as desired.

1. In the Name-Value Delimiter area, enter the delimiter string.
2. Click Allow comments after Value if you want to exclude everything after the first delimiter character. Because sections of text that do not contain the separator string are already ignored, select this option only if the separator string could occur in a comment.
3. In the Name Processing area, enter the following as desired:
   • The Name prefix is an optional string that you want to remove from the beginning of the name field. This can be useful for a file similar to the following:

     set a = 5

     set b = 10

     to remove the string set leaving just the names a and b.

   • The Name suffix is an optional string that you want removed from the end of each name.

4. In the Separators area, select the Separator that you want to use to end the value.
5. In the Trim area, select the characters to remove from the beginning and end of the value after identifying the Name/Value Separator and the Delimiter that ends the value. White space is the default and is usually sufficient.
6. In the Grouping Characters area, you can control which characters cause a value containing punctuation to be treated as a single Name/Value value. By default, all the standard ASCII quotation marks and bracket characters are recognized.

   Select the Escape Character to remove any special meaning of the character that follows it (e.g., space, comma, quotation mark, or bracket character). The escape character itself (default is backslash (\)) is always removed from the value.

   Typically, a quotation mark inside a quoted string is allowed, if the quotation mark is preceded by the escape character. Click Double quotes inside of quotes to double a quotation mark (as it is in CSV format). You can use this option to display the following text as a single string containing one double quotation mark:

   "this is a single quote""inside a quoted string"

   Clear all the options in the Grouping Characters area, and delete the default Escape Character to remove all special processing and have all characters (except the separators listed above) be treated as regular text.

Click the Advanced tab to determine the Access Mode:

Click OK to save your changes and to close the dialog box.