Specifies one or more substitution sets, each composed of an individual
character to be replaced, a character delimiter, and a substitution
string. The connector performs this substitution on an attribute's
value only if a value has been specified for the [ESC=true|false] parameter of
the attribute's AppSpecificInfo property or for the connector's
ReplaceAllStr property.
- Note:
- The ESC parameter and the ReplaceAllStr and ReplaceStrList properties provide
support for database escape character functionality (for example, to escape
single quotation marks).
The syntax for this attribute is:
single_char1,substitution_str1[:single_char2,substitution_str2[:...]]
where:
- single_char
- A character to be replaced.
- substitution_str
- The substitution string that the connector uses to replace the
character.
- ,
- The character delimiter, which separates the character to be replaced from
the string that replaces it. By default, the character delimiter is a
comma (,). You can configure this delimiter by setting the first
delimiter in theStrDelimiter property.
- :
- The termination delimiter, which separates substitution sets (each of
which is composed of the character to be replaced, a character delimiter, and
the substitution string). By default, the termination delimiter is a
colon (:). You can configure this delimiter by setting the second
delimiter in the StrDelimiter property.
For example, assume you want to replace a single percent sign
(%) with two percent signs (%%), and a caret
(^) with a backslash and a caret (\^). By
default, StrDelimiter specifies a comma (,) as the character delimiter, and a
colon (:) as the termination delimiter. If you keep the default
delimiters, use the following string as the value of
ReplaceStrList:
%,%%:^,\^
- Note:
- A restriction of the connector configuration tool prevents entering single
quotation marks. Therefore, you must represent a single quotation with
the character Q, and two single quotations with the characters
DSQ. In the above example, if you also want to substitute a
single quotation mark (') with two single quotation marks
(''), use the following notation:
Q,DSQ:%,%%:^,\^
Default value: Q,DSQ .
- Note:
- In the connector configuration tool, these characters represent a single
quotation mark, followed by a comma, followed by two single quotation
marks.
Possible values: A set composed of a single character, a character
delimiter, and the character's substitution string. Also, multiple
such sets with a termination delimiter between them.
Required: No
