Regex Dash

Is there a remove dash(-) element in this statement? REReplaceNoCase(acc_number,[^a-zA-Z[:space:]'0-9_:,!()/],,ALL) Lee Surma ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:240212 Archives:

RE: Regex Dash

: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Thursday, May 11, 2006 11:03 AM To: CF-Talk Subject: Regex Dash Is there a remove dash(-) element in this statement? REReplaceNoCase(acc_number,[^a-zA-Z[:space:]'0-9_:,!()/],,ALL) Lee Surma

Re: Regex Dash

the -, add \- to the end of the group: REReplaceNoCase(acc_number,[^a-zA-Z[:space:]'0-9_:,!()/\-],,ALL) ... Ben Nadel www.bennadel.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Thursday, May 11, 2006 11:03 AM To: CF-Talk Subject: Regex

RE: Regex Dash

- From: Rob Wilkerson [mailto:[EMAIL PROTECTED] Sent: Thursday, May 11, 2006 11:44 AM To: CF-Talk Subject: Re: Regex Dash Just placing the dash at the beginning or end of the character class should be sufficient. Otherwise the dash is considered a range delimiter. [-_A-Z] will handle dashes

Re: Regex Dash

, and it makes me feel more comfortable to know that it is being escaped... But yes, both will work. ... Ben Nadel www.bennadel.com -Original Message- From: Rob Wilkerson [mailto:[EMAIL PROTECTED] Sent: Thursday, May 11, 2006 11:44 AM To: CF-Talk Subject: Re: Regex Dash

RE: Regex Dash

\ as a special string character cause it makes reading much much easier. ... Ben Nadel www.bennadel.com -Original Message- From: Rob Wilkerson [mailto:[EMAIL PROTECTED] Sent: Thursday, May 11, 2006 12:13 PM To: CF-Talk Subject: Re: Regex Dash I guess what I'm asking

Re: Regex Dash

There is a remove anything that is not one of these characters That is what the ^ is for in the beginning. If you want a - to stay, add it in as the very last character (after the ()/ and before the ]) On 5/11/06, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: Is there a remove dash(-) element in