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