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.

Example

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.`

Example

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

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
\	\\
"	\"
LF (\n)	\r
CR (\r)	\n
TAB (\t)	\t
BACKSPACE (\b)	\b

Example

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