cancel
Showing results forย 
Search instead forย 
Did you mean:ย 

How to use java script in snaps to replace accented characters?

sjain
New Contributor

Hi, I am trying to load data from snaplogic into workday. I have a requirement to remove the accented characters from some fields and replace them. For example - โ€œรกโ€ changes to โ€œaโ€ or โ€œรŠโ€ changes to โ€œEโ€ and so on. I have found a java script which can do this. How can I use this java script in my pipeline so that it can replace these characters?

2 REPLIES 2

cstewart
Former Employee

Have you taken a look at the Script Snap?

sjain
New Contributor

Hi Everyone, I was not able to use the script snap and deadline was close so created this function

.replaceAll(โ€˜:โ€™,โ€˜โ€™).replaceAll(โ€˜}โ€™,โ€˜โ€™).replaceAll(โ€˜{โ€™,โ€˜โ€™).replaceAll(โ€˜]โ€™,โ€˜โ€™).replaceAll(โ€˜[โ€™,โ€˜โ€™).replaceAll(โ€˜|โ€™,โ€˜โ€™).replaceAll(โ€˜%โ€™,โ€˜โ€™).replaceAll(โ€˜,โ€™,โ€˜โ€™).replaceAll(โ€˜?โ€™,โ€˜โ€™).replaceAll(โ€˜=โ€™,โ€˜โ€™).replaceAll(โ€˜+โ€™,โ€˜โ€™).replaceAll(โ€˜#โ€™,โ€˜โ€™).replaceAll(โ€˜@โ€™,โ€˜โ€™).replaceAll(โ€˜~โ€™,โ€˜โ€™).replaceAll(โ€˜!โ€™,โ€˜โ€™).replaceAll(โ€˜^โ€™,โ€˜โ€™).replaceAll(โ€˜$โ€™,โ€˜โ€™).replaceAll(โ€˜*โ€™,โ€˜โ€™).replaceAll(โ€˜_โ€™,โ€˜โ€™).replaceAll(โ€˜;โ€™,โ€˜โ€™).replaceAll(โ€˜ร€โ€™,โ€˜Aโ€™).replaceAll(โ€˜รโ€™,โ€˜Aโ€™).replaceAll(โ€˜ร‚โ€™,โ€˜Aโ€™).replaceAll(โ€˜รƒโ€™,โ€˜Aโ€™).replaceAll(โ€˜ร„โ€™,โ€˜Aโ€™).replaceAll(โ€˜ร‡โ€™,โ€˜Cโ€™).replaceAll(โ€˜รˆโ€™,โ€˜Eโ€™).replaceAll(โ€˜ร‰โ€™,โ€˜Eโ€™).replaceAll(โ€˜รŠโ€™,โ€˜Eโ€™).replaceAll(โ€˜ร‹โ€™,โ€˜Eโ€™).replaceAll(โ€˜รŒโ€™,โ€˜Iโ€™).replaceAll(โ€˜รโ€™,โ€˜Iโ€™).replaceAll(โ€˜รŽโ€™,โ€˜Iโ€™).replaceAll(โ€˜รโ€™,โ€˜Iโ€™).replaceAll(โ€˜ร‘โ€™,โ€˜Nโ€™).replaceAll(โ€˜ร’โ€™,โ€˜Oโ€™).replaceAll(โ€˜ร“โ€™,โ€˜Oโ€™).replaceAll(โ€˜ร”โ€™,โ€˜Oโ€™).replaceAll(โ€˜ร•โ€™,โ€˜Oโ€™).replaceAll(โ€˜ร–โ€™,โ€˜Oโ€™).replaceAll(โ€˜ล โ€™,โ€˜Sโ€™).replaceAll(โ€˜รšโ€™,โ€˜Uโ€™).replaceAll(โ€˜ร›โ€™,โ€˜Uโ€™).replaceAll(โ€˜รœโ€™,โ€˜Uโ€™).replaceAll(โ€˜ร™โ€™,โ€˜Uโ€™).replaceAll(โ€˜รโ€™,โ€˜Yโ€™).replaceAll(โ€˜ลธโ€™,โ€˜Yโ€™).replaceAll(โ€˜ลฝโ€™,โ€˜Zโ€™).replaceAll(โ€˜ร โ€™,โ€˜aโ€™).replaceAll(โ€˜รกโ€™,โ€˜aโ€™).replaceAll(โ€˜รขโ€™,โ€˜aโ€™).replaceAll(โ€˜รฃโ€™,โ€˜aโ€™).replaceAll(โ€˜รคโ€™,โ€˜aโ€™).replaceAll(โ€˜รงโ€™,โ€˜cโ€™).replaceAll(โ€˜รจโ€™,โ€˜eโ€™).replaceAll(โ€˜รฉโ€™,โ€˜eโ€™).replaceAll(โ€˜รชโ€™,โ€˜eโ€™).replaceAll(โ€˜รซโ€™,โ€˜eโ€™).replaceAll(โ€˜รฌโ€™,โ€˜iโ€™).replaceAll(โ€˜รญโ€™,โ€˜iโ€™).replaceAll(โ€˜รฎโ€™,โ€˜iโ€™).replaceAll(โ€˜รฏโ€™,โ€˜iโ€™).replaceAll(โ€˜รฑโ€™,โ€˜nโ€™).replaceAll(โ€˜รฒโ€™,โ€˜oโ€™).replaceAll(โ€˜รณโ€™,โ€˜oโ€™).replaceAll(โ€˜รดโ€™,โ€˜oโ€™).replaceAll(โ€˜รตโ€™,โ€˜oโ€™).replaceAll(โ€˜รถโ€™,โ€˜oโ€™).replaceAll(โ€˜ลกโ€™,โ€˜sโ€™).replaceAll(โ€˜รนโ€™,โ€˜uโ€™).replaceAll(โ€˜รบโ€™,โ€˜uโ€™).replaceAll(โ€˜รปโ€™,โ€˜uโ€™).replaceAll(โ€˜รผโ€™,โ€˜uโ€™).replaceAll(โ€˜รฝโ€™,โ€˜yโ€™).replaceAll(โ€˜รฟโ€™,โ€˜yโ€™).replaceAll(โ€˜ลพโ€™,โ€˜zโ€™)