This section describes how to escape strings in your transformstransformations.
In the platform, the backslash character (
\) is used to escape values within strings. The character following the escaping character is treated as a string literal.
For example, the following value is used to represent a matching value of
Escaping can be applied to parameters in functions. For example, in the data grid, you have the following values in a column:
To find the value
can't, you could enter the following pattern:
The above transform transformation results in the following:
Below, you can see how this JSON pattern is specified in an example
unnest transformthe following example transformation:
keysvalue must be single-quoted. Since the keys are specified for Object data, the square bracket notation is used.
- Within the square brackets, the individual keys must be double-quoted.
- The first two backslashes (
\\) indicate that you are escaping a single backslash character.
- The third backslash indicates that you are escaping the double-quote that is part of the string to match.
In the following example, you are trying to match on the above string, including the double-quotes around it:
The bracketing double-quotes must be escaped, too.