Re: Quick Regex Question

2010-10-29 Thread CDCaveman
unsubscribe In a message dated 10/29/2010 10:41:43 A.M. Eastern Daylight Time, rob...@austin-williams.com writes: I have the regex statement - ReReplace(new_dir,"\W","","all") That removes all non-alphanumeric characters from a sting. If I want to remove all non-alphanumeric characte

Re: Quick Regex Question

2010-10-29 Thread Nathan Strutz
Robert, Actually, the underscore is counted as an alphanumeric in regular expressions. Try just replacing \W with nothing and see what you get. nathan strutz [http://www.dopefly.com/] [http://hi.im/nathanstrutz] On Fri, Oct 29, 2010 at 7:41 AM, Robert Harrison wrote: > > I have the regex sta

NEVER MIND: Quick Regex Question

2010-10-29 Thread Robert Harrison
- ReReplace(new_dir,"\W","","all") is any alphanumeric character and the _ Never Mind. Thanks Robert B. Harrison Director of Interactive Services Austin & Williams 125 Kennedy Drive, Suite 100 Hauppauge NY 11788 P : 631.231.6600 Ext. 119 F : 631.434.7022 http://www.austin-williams.com Great

Quick Regex Question

2010-10-29 Thread Robert Harrison
I have the regex statement - ReReplace(new_dir,"\W","","all") That removes all non-alphanumeric characters from a sting. If I want to remove all non-alphanumeric characters except the underscore, is that:ReReplace(new_dir,"\W/_","","all") or ? Thanks Robert B. Harrison Director of Intera

Re: Quick Regex question

2006-03-01 Thread Michael Traher
may have nothing to do with it but did you know that if you read a quote comma delimited file using cfhttp it returns a query and it handles that kind of commas in a field stuff for you. On 3/1/06, Andy Matthews <[EMAIL PROTECTED]> wrote: > > How would I go about finding a comma, found between tw

RE: Quick Regex question

2006-03-01 Thread Andy Matthews
No no... I meant any comma found inside double quotes. It will most likely be between words (or names). -Original Message- From: Gareth [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 01, 2006 9:19 AM To: CF-Talk Subject: Re: Quick Regex question Likewise :) In which case your first

Re: Quick Regex question

2006-03-01 Thread Gareth
Likewise :) In which case your first suggestion of replacing the one you want to keep first is probably the most robust solution. - Original Message - From: "Jerry Johnson" <[EMAIL PROTECTED]> To: "CF-Talk" Sent: Wednesday, March 01, 2006 3:13 PM Subject: Re

Re: Quick Regex question

2006-03-01 Thread Jerry Johnson
I took "between double quotes" to mean "within the string delimited fields" rather than the more literal "comma surrounded immediately by quotes" On 3/1/06, Gareth <[EMAIL PROTECTED]> wrote: > I dont get it :) > > You say find the comma between double quotes but then you say 'only want to > replac

Re: Quick Regex question

2006-03-01 Thread Gareth
t;," will do it). If it's the second this might work: From: #str# To: #ReReplace(str, ',[^",],*', ' ', "ALL")# - Original Message - From: "Andy Matthews" <[EMAIL PROTECTED]> To: "CF-Talk" Sent: Wednesday, Ma

Re: Quick Regex question

2006-03-01 Thread Jerry Johnson
I typically do this in two steps (replace the one I want to keep (",") with a placeholder (often the bell character)), and then do a replace for the comma, and then replace the placeholder. But, trying to do it your way... rereplace(string,"([^""]),([^""])","/1/2","ALL") This won't handle a comm

RE: Quick Regex question

2006-03-01 Thread Andy Matthews
Thanks Adrian... I'll look at that one. Appreciated. -Original Message- From: Adrian Lynch [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 01, 2006 8:39 AM To: CF-Talk Subject: RE: Quick Regex question From: #str# To: #REReplac

RE: Quick Regex question

2006-03-01 Thread Adrian Lynch
From: #str# To: #REReplace(str, '","', '"|"', "ALL")# -Original Message- From: Andy Matthews [mailto:[EMAIL PROTECTED] Sent: 01 March 2006 14:33 To: CF-Talk Subject: Quick Regex question How would I

Quick Regex question

2006-03-01 Thread Andy Matthews
How would I go about finding a comma, found between two double quotes? For example: "James","Matthews, Andy" I only want to replace the comma between Matthews and Andy, but not the comma between James and Matthews. ~| Message

RE: Quick Regex question

2006-02-20 Thread Andy Matthews
he string to an actual XML object with XMLParse and get at the contents like that. So thanks. -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Monday, February 20, 2006 4:16 PM To: CF-Talk Subject: RE: Quick Regex question > I need to pull some text out of XML and I

Re: Quick Regex question

2006-02-20 Thread Claude Schneegans
>>I want to get the contents of each of these XML nodes. Have a look at CF_REextract: http://www.contentbox.com/claude/customtags/REextract/testREextract.cfm?p=hf -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm

RE: Quick Regex question

2006-02-20 Thread Eric Lackey
4:10 PM To: CF-Talk Subject: Quick Regex question I need to pull some text out of XML and I wanted to see how that might work. I've got this text: Jason Martin I want to get the contents of each of these XML nodes. What might be the best way of

RE: Quick Regex question

2006-02-20 Thread Dave Watts
> I need to pull some text out of XML and I wanted to see how > that might work. I've got this text: > > Jason > Martin > > I want to get the contents of each of these XML nodes. What > might be the best way of doing this? Why not just use an XML parser? Dave Watts, CTO, Fig Leaf Software htt

RE: Quick Regex question

2006-02-20 Thread Tim Heald
Using what? Why not just pull it out with CF? Why use a regex? > -Original Message- > From: Andy Matthews [mailto:[EMAIL PROTECTED] > Sent: Monday, February 20, 2006 5:10 PM > To: CF-Talk > Subject: Quick Regex question > > I need to pull some text out of XML an

Quick Regex question

2006-02-20 Thread Andy Matthews
I need to pull some text out of XML and I wanted to see how that might work. I've got this text: Jason Martin I want to get the contents of each of these XML nodes. What might be the best way of doing this? ~| Message: http:/