Text Parameters Modifiers

To modify values of the parameters, you can use modifiers. The syntax for using modifiers is as follows:

    %<mod1|mod2|...|modN>ParameterName%

When multiple modifiers are supplied they are applied in the order they appear in the list. Available modifiers are:

• adj - Adjusts the text by converting each white space sequence (space, tab, line feed, etc.) into a single space character.
• adjlb - Same as adj, but preserves line breaks.
• sql - Duplicates each single quote ( ' ) character found in the text, making it safe for using in SQL queries.
• url - Converts text to URL encoded string.
• ahex - Converts text to hex encoded string (for example, converts abc to 616263).
• uhexl - Converts text to Unicode and then to hex encoded string using little-endian byte order (for example, converts abc to 610062006300).
• uhexb - Converts text to Unicode and then to hex encoded string using big-endian byte order (for example, converts abc to 006100620063).

For example:

• %<url>MsgText% - returns the value of the %MsgText% parameter converted to URL encoded string. This will convert Hello Mike into Hello%20Mike.
• %<sql>MsgText% - returns the value of the %MsgText% parameter with duplicated apostrophe characters. This will convert Hello 'Mike' into Hello ''Mike''.
• %<sql|url>MsgText% - returns the value of the %MsgText% parameter with duplicated apostrophe characters and then converted to URL encoded string. This will convert Hello 'Mike' into Hello%20%27%27Mike%27%27.