We have a few users who like to paste characters from the ASCII extended character set into a couple of character fields. This wouldn’t be a problem if it weren’t for an external process that can’t handle the characters. Ideally we would modify the external process, but, that is not an option at this time.
I have been unsuccessful at detecting the extended characters with something like ‘fieldname’ LIKE “%[€]%” in the run if of an active link. I’ve also tried to limit the characters accepted in the field using ‘fieldname’ LIKE “%[^a-za-z0...@#$&*]%”. This list is not complete, but, makes the point. With the latter method it seemed everything checked out except that I can’t figure out how to exclude the right bracket “]”. Any ideas on how I can detect the extended characters or enforce only the characters from the standard character set? I need to only check two fields so a system or database setting would not seem appropriate. Thanks! Oracle 10g (Linux) ARS 7.1 patch 6 including mid-tier (Windows 2003 server) Apache/TomCat Bill Myers Sr. Remedy Developer Datacraft Solutions, Inc.
