However, when you receive the data from clients in comma delimited files, or have no control over the collection of the data....not much recourse.
> -----Original Message----- > From: [email protected] [mailto:u2-users- > [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
