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
