Page Comparison

In this article

Table of Contents

maxLevel	4
minLevel	1
absoluteUrl	true
exclude	Older 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.

...

Widget Connector

overlay	youtube
_template	com/atlassian/confluence/extra/widgetconnector/templates/youtube.vm
width	400px
url	http://youtube.com/watch?v=NwwujRSCgvk
height	300px

SnapLogic Best Practices: Data Transformations and Mappings

Widget Connector

overlay	youtube
_template	com/atlassian/confluence/extra/widgetconnector/templates/youtube.vm
width	400px
url	http://youtube.com/watch?v=SfEuG7Dg_O8
height	300px

...

Insert excerpt