Something we used on our old ERP system was to define all valid characters, and use this against a copy of the input string to remove all valid characters, then use the remaining string (if anything remains...it's not valid) against the original input string.
HTH Drew -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of [email protected] Sent: Wednesday, January 12, 2011 7:31 PM To: U2 Users List Subject: Re: [U2] Special Character Handling I know I'm not answering the original question "Is there a tool.... ", but if the validation is on-line, it would be best to manage a list of valid characters, rather than do converts of specific characters. Bearing in mind that users can copy-paste into your input field, or type Alt+nnn you can easily get trash in your database, that later comes back to haunt you when you export to excel, try to put together an SQL query, etc. If it's a web-based app, there are security issues and you definitely should have a set of valid characters. Regards, Marc On Wed, 12 Jan 2011 04:10:52 -0600, George Gallen <[email protected]> wrote: > Depends on which special characters....If you mean accented letters, > I use a subroutine that converts the accented > high ASCII code to it's non-accented letter. (EX. e' to e). > > Basically, it's just a bunch of converts. But it's good for > converting data that was entered via a website text entry > where foreign letters can be entered. The hard part is collecting all > the possible accented letters. > > George > > George Gallen > Senior Programmer/Analyst > Accounting/Data Division > [email protected] > ph:856.848.9005 Ext 220 > The Wyanoke Group > http://www.wyanokegroup.com > ________________________________________ > From: [email protected] > [[email protected]] On Behalf Of Ron Hutchings > [[email protected]] > Sent: Tuesday, January 11, 2011 6:10 PM > To: [email protected] > Subject: [U2] Special Character Handling > > Is there a tool to remove special characters from a text file? Other > than a roll your own with convert or replace in a program? > > _______________________________________________ > U2-Users mailing list > [email protected] > http://listserver.u2ug.org/mailman/listinfo/u2-users > _______________________________________________ > U2-Users mailing list > [email protected] > http://listserver.u2ug.org/mailman/listinfo/u2-users _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users
