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

Question

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?

cstewart · Answer

Have you taken a look at the Script Snap?

sjain · Answer

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’)

Forum Discussion

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

Recent Discussions

Javascript to promote top level lists

Google Sheets Subscribe questions

Basic string transformations not working

Can we generate XML file in pretty print format using native snapLogic snaps?

Multipart Reader failure - 'content-type' was not found