[thelist] ColdFusion - Remove special characters
jon steele
jjsteele22 at yahoo.com
Mon May 7 17:28:58 CDT 2001
Hi,
I need to take a string, and replace any special characters (i.e.
periods, '&', space, etc). This is because I am taking input for a
table name, and an error will be produced if there is, for example, an
& in the table name.
Currently, I just replace spaces with underscores.
How can I remove any other characters which cannot exist in a table
name. I'm using MS Access.
Thanks,
Jon.
__________________________________________________
Do You Yahoo!?
Yahoo! Auctions - buy the things you want at great prices
http://auctions.yahoo.com/
More information about the thelist
mailing list