[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