Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Published by Scroll Versions from space DEV and version next

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.

...

D trans
p03Value'MyFindResults'
Typestep
p01NameFormula type
p01ValueSingle row formula
p02NameFormula
p02ValueFIND(MyStringCol, 'can\'t',true,0)
p03NameNew column name
SearchTermNew formula

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:

D trans
Typestep
p01NameColumn
p01ValueMyCol
p02NamePaths to elements
p02Value[\"re\\\"becca\"]
SearchTermPivot columns

...