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