Paul, check out the following functions: SKEEP or SKEEPI SSTRIP OR SSTRIPI Jim Bentley American Celiac Society [email protected] tel: 1-504-737-3293
----- Original Message ---- From: Paul Buckley <[email protected]> To: RBASE-L Mailing List <[email protected]> Sent: Tue, November 17, 2009 12:49:34 PM Subject: [RBASE-L] - Brain Freeze on Stripping Spaces and Characters from a String I know I'm missing something simple, probably not enough caffeine today. I'm trying to setup a computed column in a table that will strip all spaces from the string and replace all the non-alpha or numeric characters with an underscore (_). Here's some examples; First & Third would become First_Third, First/Third would become First_Third and Item # would become Item_. Can someone suggest a way to do this please. Thanks in advance. Paul Buckley
