Re: Reg Expression to revome (most) punctuation

2006-03-28 Thread cf
Hi, rereplacenocase(string, '[a-z0-9 ]+', '', 'all') This will remove every occurences of a character that is NOT within the range of A-Z (both cases), 0-9 or a space. Actually this will remove only letters number and spaces... to negate the range., you need a caret:

Re: Reg Expression to revome (most) punctuation

2006-03-28 Thread Michael Dinowitz
You are correct. When I typed it I thought I had the carrat there but I guess not. When I make such a simple mistake then it's a good sign that I need sleep. For a little more info on Regex, these are some presentations of mine on the subject: http://houseoffusion.com/_regex/presentation/

Re: Reg Expression to revome (most) punctuation

2006-03-28 Thread Paul Giesenhagen
Perfect ... thanks! Paul Giesenhagen QuillDesign 417-885-1375 http://www.quilldesign.com - Original Message - From: [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Tuesday, March 28, 2006 2:06 AM Subject: Re: Reg Expression to revome (most) punctuation Hi

Reg Expression to revome (most) punctuation

2006-03-27 Thread Paul Giesenhagen
I know this will be simple for some .. but it isn't for me .. I have tried to find something for this. I need to remove all punctuation except for spaces between words. I only want alpha and numeric (plus spaces) left. Example: Str = I don't remember, if it was 12 or 12'? Result = I dont

Re: Reg Expression to revome (most) punctuation

2006-03-27 Thread Michael Dinowitz
rereplacenocase(string, '[a-z0-9 ]+', '', 'all') This will remove every occurences of a character that is NOT within the range of A-Z (both cases), 0-9 or a space. This will include ANY non-number/letter character so if there is something you want to keep, it has to be included within the