Join the #BuildWithBuildAgent Challenge! Get recognized, earn exclusive swag, and inspire the ServiceNow Community with what you can build using Build Agent.  Join the Challenge.

Special characters being imported as jibberish

Patrick Tipps1
Tera Contributor

Hi everyone,

 

In the instance I work in there is a scheduled import that activates every 30 minutes, loading users into the system. 

Some of these users that have special characters in their name like 'ń' and the character that ServiceNow receives contain values such as 'ñ' instead. 

 

Normalizing these string values isn't working because 'ñ' is not being updated to 'ń' using the normalize function. Another example is that 'ó' is being imported as 'ó'.

 

I've been asked to write a field map script that will update these values to their 'correct' values but I'm not sure how to do that considering normalize() considers values like 'Ã' to be A, not ń.

 

Is there any way to do this?

0 REPLIES 0