Updating an Existing Vector 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 area.

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 Separators area, select the Separator that you want to use to end the value.
2. In the Trim area, select the characters to remove from the start and the end of the value.
3. In the Grouping Characters area, you can control which characters cause a value containing punctuation to be treated as a single vector element. By default, all the standard ASCII quotation marks and bracket characters are recognized, and the following string is treated as a vector of length 3, where the third element is 3 lines:

   1.23, "a quoted value," (table inside vector

   2, 3, 4

   5, 6, 7)

   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.