Skip to main content
Version: User Guide 6.5

Escaping Modifiers

Escaping for SQL​

EscSQL prepares a field value to be eclosed in single quotes. It duplicates all single quotes the field value has already.

Example

For {MESSAGE} equals abc 'xyz',
{MESSAGE|EscSQL} produces abc ''xyz''

Escaping for CSV​

EscCSV prepares a field value to be eclosed in double quotes. It duplicates all double quotes the field value has already.

Example

For {MESSAGE} equals abc "xyz",
{MESSAGE|EscCSV} produces abc ""abc""

Escaping for HTML​

EscHTML prepares a field value to be included in HTML-formatted output.

Escaping for JSON​

EscJSON prepares a field value to be included in JSON-formatted output.

CharacterReplaced with
\\\
"\"
LF (\n)\r
CR (\r)\n
TAB (\t)\t
BACKSPACE (\b)\b
Example

For {MESSAGE} equals \abc "xyz",
{MESSAGE|EscJSON} produces \\abc \"abc\"