ASCII to UTF 8 Encoding issues
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-21-2016 02:41 AM
Hi,
In the Department table of ServiceNow, one of the Department has name as GGO MENA â€" ALL ( which has ASCII characters in it). This is one such example. Now, such values are already loaded into ServiceNow from another source.
Now, when i try to search the same in Department Table with exact name the search returns no results. Tried changing the Encoding to various other formats in chrome but no results returned.
Can you kindly let me know how can we search for such values, now the value stored in table cannot be modified , we need an effective means to search such values
Regards,
Vidya
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-21-2016 06:35 AM
Hi Vidya,
I'm not sure I understand the issue. Is the entry in the department table contain the UTF characters? Are those coming from an import source and not showing up?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-13-2016 12:11 PM
Hi Chuck - the problem we have is that we're ingesting data from a .csv file, and some of the data in that CSV file has the â€" character in it. What we need to do is change that â€" character to a - character upon transformation into the department table.
Would an onBefore transform script handle this?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-13-2016 01:36 PM
If it's just one field that's doing that, you can do that in the transform script with a simple search/replace.
See Episodes 31/32 here for more information on RegEx.
