Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

In this article

Table of Contents
maxLevel4
minLevel1
absoluteUrltrue
excludeOlder Versions|Additional Resources|Related Links|Related Information

...

If the Escape Character is 

Use Expression

Sample Output 

Single quote (') 

JSON:

$original.mapValues((value,key)=> value.toString().replaceAll("'","''"))

OR

$original.mapValues((value,key)=> value.toString().replaceAll("'","\''"))

CSV:

$[' Business-Name'].replace ("'","''")

Ampersand (&)


JSON:

$original.mapValues((value,key)=> value.toString().replaceAll("'","\&'"))

OR

$original.mapValues((value,key)=> value.toString().replaceAll("'","&'"))

CSV:

$[' Business-Name'].replace ("'","&'")

Backslash (\)




JSON:

$original.mapValues((value,key)=> value.toString().replaceAll("'","\\'"))

Info

Backslash is configured as an escape character in SnapLogic. Therefore, it must itself be escaped to be displayed as text. 

CSV:

$[' Business-Name'].replace ("'","\\'")

In this way, you can customize the data to be passed on to downstream Snaps using the Expression field in the Mapper Snap. 

...

Insert excerpt
Transform Snap Pack
Transform Snap Pack
nopaneltrue