[thelist] ColdFusion - Remove special characters

jon steele jjsteele22 at yahoo.com
Mon May 7 17:28:58 CDT 2001


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.


Do You Yahoo!?
Yahoo! Auctions - buy the things you want at great prices

More information about the thelist mailing list