In this article
Table of Contents | ||||||||
---|---|---|---|---|---|---|---|---|
|
...
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("'","\\'"))
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 | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|
|
SnapLogic Best Practices: Data Transformations and Mappings
Widget Connector | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|
|
...
Community Links:
Insert excerpt | ||||||
---|---|---|---|---|---|---|
|