Escape Modifiers

Exporting to specific formats limits the characters that can be used in the output. The modifiers below prepare data from fields for a specific format.

Prepare for SQL

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

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

Prepare for CSV

EscCSV prepares a field value to be enclosed in double quotes. It duplicates all existing double quotes.

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

Prepare for HTML

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

Prepare for JSON

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

Character Replaced with

Character	Replaced with
`\`	`\\`
`"`	`\"`
LF (\n)	`\r`
CR (\r)	`\n`
TAB (\t)	`\t`
BACKSPACE (\b)	`\b`

\

\\

"

\"

LF (\n)

\r

CR (\r)

\n

TAB (\t)

\t

BACKSPACE (\b)

\b

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