09-13-2020 09:03 AM
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?
09-13-2020 06:35 PM
Have you taken a look at the Script Snap?
09-30-2020 03:56 AM
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’)