[cfaussie] Re: RegEx to greedy
If you didn't find the regex plugin intuitiev, you may find the following website useful. It has a lot of useful info on regexes. http://www.regularexpressions.info Spike Stephen Milligan Code poet for hire http://www.spike.org.uk Do you cfeclipse? http://cfeclipse.tigris.org -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Tuesday, September 14, 2004 10:26 PM To: CFAussie Mailing List Subject: [cfaussie] Re: RegEx to greedy yes that would be the plugin, but the same problem with other plug ins to, I opened my mind - just could not immediately find my way around it. Will try more when I have time.. Im sure its a good tool and I'll start to love it once I know my way around it.. On 15 Sep 2004 at 15:08, Gareth Edwards wrote: Taco Couldnt find your way around Eclipse? the certain plugin your talking about wouldnt be cfeclipse would it? It is so easy to get everything running, you just need to open your mind to it a little. What parts were you having troubles with? Its a wonderful tool. Especially if you use CVS, something I think it is something that Macromedia should have a look at. Gareth. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of [EMAIL PROTECTED] Sent: Wednesday, 15 September 2004 2:54 PM To: CFAussie Mailing List Subject: [cfaussie] Re: RegEx to greedy Yeah I installed eclipse, but could not find my way around it. Could not find out how to run a certain plugin either... On 15 Sep 2004 at 14:39, Andrew Muller wrote: Taco If you're using Eclipse there's a great plugin to test regex available (even better, like Eclipse it's free): Robin demonstrated it at a recent CFUG here in Sydney: http://www.rocketboots.com.au/blog/index.cfm?mode=entryentry=6 FAD4671-E081- 51EF- A7B266ACE05CC38A Andrew On Wed, 15 Sep 2004 14:21:53 +1000, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: got it. no worries On 15 Sep 2004 at 14:05, [EMAIL PROTECTED] wrote: text a href=link I wanttext I might be wanting/a text a href=link I wanttext I might be wanting/a cfset form.contentHTML = reReplaceNoCase( form.contentHTML, 'a href=(.*[^]+).*[^]+/a', [ copy and paste link: \1 ] , all ) / Is being to greedy, and I can't seem to get my head around it, anyone? -- Taco Fleur Senior Web Systems Engineer http://www.webassociates.com --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] Aussie Macromedia Developers: http://lists.daemon.com.au/ -- Taco Fleur Senior Web Systems Engineer http://www.webassociates.com --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] Aussie Macromedia Developers: http://lists.daemon.com.au/ --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] Aussie Macromedia Developers: http://lists.daemon.com.au/ -- Taco Fleur Senior Web Systems Engineer http://www.webassociates.com --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] Aussie Macromedia Developers: http://lists.daemon.com.au/ --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] Aussie Macromedia Developers: http://lists.daemon.com.au/
[cfaussie] Re: RegEx to greedy
Donations please to the benevelont cfeclipse developers fund :) Beer is acceptable ;) Spike Stephen Milligan Code poet for hire http://www.spike.org.uk Do you cfeclipse? http://cfeclipse.tigris.org -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of M@ Bourke Sent: Tuesday, September 14, 2004 10:34 PM To: CFAussie Mailing List Subject: [cfaussie] Re: RegEx to greedy Eclipse Rocks For CFC's Brilliant for browsing CFCs and seeing all the methods in the CFC bit on the right. I can eventually see Eclipse destroying dreamweaver as a development tool, and eventually dreamweaver will just have a designer user base. You can pay half an arm for DreamWeaver or get a far much superior product that is free :). I know what the majority of CF developers weapon of choice will be in a year. --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] Aussie Macromedia Developers: http://lists.daemon.com.au/ --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] Aussie Macromedia Developers: http://lists.daemon.com.au/
[cfaussie] Re: RegEx to greedy
Can it feed my dog and water the garden on Wednesday and Friday? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Steve Onnis Sent: Wednesday, 15 September 2004 4:44 PM To: CFAussie Mailing List Subject: [cfaussie] Re: RegEx to greedy how about speach recognition? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Gareth Edwards Sent: Wednesday, September 15, 2004 4:20 PM To: CFAussie Mailing List Subject: [cfaussie] Re: RegEx to greedy If we donate can we list the things we want? ie. that difficult task (code folding)? Gareth. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Spike Sent: Wednesday, 15 September 2004 4:17 PM To: CFAussie Mailing List Subject: [cfaussie] Re: RegEx to greedy Donations please to the benevelont cfeclipse developers fund :) Beer is acceptable ;) Spike Stephen Milligan Code poet for hire http://www.spike.org.uk Do you cfeclipse? http://cfeclipse.tigris.org -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of M@ Bourke Sent: Tuesday, September 14, 2004 10:34 PM To: CFAussie Mailing List Subject: [cfaussie] Re: RegEx to greedy Eclipse Rocks For CFC's Brilliant for browsing CFCs and seeing all the methods in the CFC bit on the right. I can eventually see Eclipse destroying dreamweaver as a development tool, and eventually dreamweaver will just have a designer user base. You can pay half an arm for DreamWeaver or get a far much superior product that is free :). I know what the majority of CF developers weapon of choice will be in a year. --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] Aussie Macromedia Developers: http://lists.daemon.com.au/ --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] Aussie Macromedia Developers: http://lists.daemon.com.au/ --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] Aussie Macromedia Developers: http://lists.daemon.com.au/ --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] Aussie Macromedia Developers: http://lists.daemon.com.au/ --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] Aussie Macromedia Developers: http://lists.daemon.com.au/
[cfaussie] Re: RegEx to greedy
got it. no worries On 15 Sep 2004 at 14:05, [EMAIL PROTECTED] wrote: text a href=link I wanttext I might be wanting/a text a href=link I wanttext I might be wanting/a cfset form.contentHTML = reReplaceNoCase( form.contentHTML, 'a href=(.*[^]+).*[^]+/a', [ copy and paste link: \1 ] , all ) / Is being to greedy, and I can't seem to get my head around it, anyone? -- Taco Fleur Senior Web Systems Engineer http://www.webassociates.com --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] Aussie Macromedia Developers: http://lists.daemon.com.au/ -- Taco Fleur Senior Web Systems Engineer http://www.webassociates.com --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] Aussie Macromedia Developers: http://lists.daemon.com.au/
[cfaussie] Re: RegEx to greedy
Taco If you're using Eclipse there's a great plugin to test regex available (even better, like Eclipse it's free): Robin demonstrated it at a recent CFUG here in Sydney: http://www.rocketboots.com.au/blog/index.cfm?mode=entryentry=6FAD4671-E081-51EF-A7B266ACE05CC38A Andrew On Wed, 15 Sep 2004 14:21:53 +1000, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: got it. no worries On 15 Sep 2004 at 14:05, [EMAIL PROTECTED] wrote: text a href=link I wanttext I might be wanting/a text a href=link I wanttext I might be wanting/a cfset form.contentHTML = reReplaceNoCase( form.contentHTML, 'a href=(.*[^]+).*[^]+/a', [ copy and paste link: \1 ] , all ) / Is being to greedy, and I can't seem to get my head around it, anyone? -- Taco Fleur Senior Web Systems Engineer http://www.webassociates.com --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] Aussie Macromedia Developers: http://lists.daemon.com.au/
[cfaussie] Re: RegEx to greedy
Taco Couldnt find your way around Eclipse? the certain plugin your talking about wouldnt be cfeclipse would it? It is so easy to get everything running, you just need to open your mind to it a little. What parts were you having troubles with? Its a wonderful tool. Especially if you use CVS, something I think it is something that Macromedia should have a look at. Gareth. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of [EMAIL PROTECTED] Sent: Wednesday, 15 September 2004 2:54 PM To: CFAussie Mailing List Subject: [cfaussie] Re: RegEx to greedy Yeah I installed eclipse, but could not find my way around it. Could not find out how to run a certain plugin either... On 15 Sep 2004 at 14:39, Andrew Muller wrote: Taco If you're using Eclipse there's a great plugin to test regex available (even better, like Eclipse it's free): Robin demonstrated it at a recent CFUG here in Sydney: http://www.rocketboots.com.au/blog/index.cfm?mode=entryentry=6FAD4671-E081-51EF- A7B266ACE05CC38A Andrew On Wed, 15 Sep 2004 14:21:53 +1000, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: got it. no worries On 15 Sep 2004 at 14:05, [EMAIL PROTECTED] wrote: text a href=link I wanttext I might be wanting/a text a href=link I wanttext I might be wanting/a cfset form.contentHTML = reReplaceNoCase( form.contentHTML, 'a href=(.*[^]+).*[^]+/a', [ copy and paste link: \1 ] , all ) / Is being to greedy, and I can't seem to get my head around it, anyone? -- Taco Fleur Senior Web Systems Engineer http://www.webassociates.com --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] Aussie Macromedia Developers: http://lists.daemon.com.au/ -- Taco Fleur Senior Web Systems Engineer http://www.webassociates.com --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] Aussie Macromedia Developers: http://lists.daemon.com.au/ --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] Aussie Macromedia Developers: http://lists.daemon.com.au/
[cfaussie] Re: RegEx to greedy
yes that would be the plugin, but the same problem with other plug ins to, I opened my mind - just could not immediately find my way around it. Will try more when I have time.. Im sure its a good tool and I'll start to love it once I know my way around it.. On 15 Sep 2004 at 15:08, Gareth Edwards wrote: Taco Couldnt find your way around Eclipse? the certain plugin your talking about wouldnt be cfeclipse would it? It is so easy to get everything running, you just need to open your mind to it a little. What parts were you having troubles with? Its a wonderful tool. Especially if you use CVS, something I think it is something that Macromedia should have a look at. Gareth. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of [EMAIL PROTECTED] Sent: Wednesday, 15 September 2004 2:54 PM To: CFAussie Mailing List Subject: [cfaussie] Re: RegEx to greedy Yeah I installed eclipse, but could not find my way around it. Could not find out how to run a certain plugin either... On 15 Sep 2004 at 14:39, Andrew Muller wrote: Taco If you're using Eclipse there's a great plugin to test regex available (even better, like Eclipse it's free): Robin demonstrated it at a recent CFUG here in Sydney: http://www.rocketboots.com.au/blog/index.cfm?mode=entryentry=6FAD4671-E081- 51EF- A7B266ACE05CC38A Andrew On Wed, 15 Sep 2004 14:21:53 +1000, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: got it. no worries On 15 Sep 2004 at 14:05, [EMAIL PROTECTED] wrote: text a href=link I wanttext I might be wanting/a text a href=link I wanttext I might be wanting/a cfset form.contentHTML = reReplaceNoCase( form.contentHTML, 'a href=(.*[^]+).*[^]+/a', [ copy and paste link: \1 ] , all ) / Is being to greedy, and I can't seem to get my head around it, anyone? -- Taco Fleur Senior Web Systems Engineer http://www.webassociates.com --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] Aussie Macromedia Developers: http://lists.daemon.com.au/ -- Taco Fleur Senior Web Systems Engineer http://www.webassociates.com --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] Aussie Macromedia Developers: http://lists.daemon.com.au/ --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] Aussie Macromedia Developers: http://lists.daemon.com.au/ -- Taco Fleur Senior Web Systems Engineer http://www.webassociates.com --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] Aussie Macromedia Developers: http://lists.daemon.com.au/
[cfaussie] Re: RegEx to greedy
Eclipse Rocks For CFC's Brilliant for browsing CFCs and seeing all the methods in the CFC bit on the right. I can eventually see Eclipse destroying dreamweaver as a development tool, and eventually dreamweaver will just have a designer user base. You can pay half an arm for DreamWeaver or get a far much superior product that is free :). I know what the majority of CF developers weapon of choice will be in a year. --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] Aussie Macromedia Developers: http://lists.daemon.com.au/
[cfaussie] Re: RegEx to greedy
Yeah I installed eclipse, but could not find my way around it. Could not find out how to run a certain plugin either... On 15 Sep 2004 at 14:39, Andrew Muller wrote: Taco If you're using Eclipse there's a great plugin to test regex available (even better, like Eclipse it's free): Robin demonstrated it at a recent CFUG here in Sydney: http://www.rocketboots.com.au/blog/index.cfm?mode=entryentry=6FAD4671-E081-51EF- A7B266ACE05CC38A Andrew On Wed, 15 Sep 2004 14:21:53 +1000, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: got it. no worries On 15 Sep 2004 at 14:05, [EMAIL PROTECTED] wrote: text a href=link I wanttext I might be wanting/a text a href=link I wanttext I might be wanting/a cfset form.contentHTML = reReplaceNoCase( form.contentHTML, 'a href=(.*[^]+).*[^]+/a', [ copy and paste link: \1 ] , all ) / Is being to greedy, and I can't seem to get my head around it, anyone? -- Taco Fleur Senior Web Systems Engineer http://www.webassociates.com --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] Aussie Macromedia Developers: http://lists.daemon.com.au/ -- Taco Fleur Senior Web Systems Engineer http://www.webassociates.com --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] Aussie Macromedia Developers: http://lists.daemon.com.au/
[cfaussie] RE: RegEx replace in Studio
A backslash followed by the match number. A nice oversimplified example: Find: option([^0-9]*)([0-9]*)/option Replace: option value=\2\1\2/option If you do a search for 'Using regular expressions' in the studio docs you'll find the help for it. RegEx rocks. [EMAIL PROTECTED] wrote: Question for the RegEx gurus out there (and something I should have learned years ago!) - How do you use RegEx backreferences in Studio's find and replace? I want to use all or part of the matched character string from the Find in the Replace eg. say I have this code optionfoo 1/option optionbar 2/option I want to do a regex replace so it ends up as: option value=1foo 1/option option value=2bar 2/option I can write a regex to match the input string ok. It's using that match (or part of the match) in the replace that I can't work out. Any clues? -- Lindsay Evans. Developer, Red Square Productions. [p] 8596.4000 [f] 8596.4001 [w] www.redsquare.com.au --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004
[cfaussie] RE: regex....
Hi Kevin, Try reReplaceNoCase(someString,'[aeiou]','','all') Regards, Mina Mina Sabag Web Developer E-Commerce Tourism Queensland Looking for accommodation at discount prices? www.BestRates.com.au -Original Message- From: Kevin Faulkner [mailto:[EMAIL PROTECTED] Sent: Wednesday, 24 March 2004 9:14 AM To: CFAussie Mailing List Subject: [cfaussie] regex Hi All, Has anyone any pointers as to the regex for removing all vowels from a string, I know I could do it with 5 normal replaces, but am trying to increase my non-existant regex knowledge. Cheers, Kev --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004 --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004
[cfaussie] RE: regex....
Thanks Mina, I was actually just looking into that, but I think abbreviating only replaces vowels that aren't at the start of the word? Could I replace all vowels that aren't either at the start of a string or preceeded by a space? - Original Message - From: Mina Sabag [EMAIL PROTECTED] To: CFAussie Mailing List [EMAIL PROTECTED] Sent: Wednesday, March 24, 2004 10:24 AM Subject: [cfaussie] RE: regex Hi Kevin, Try reReplaceNoCase(someString,'[aeiou]','','all') Regards, Mina Mina Sabag Web Developer E-Commerce Tourism Queensland Looking for accommodation at discount prices? www.BestRates.com.au -Original Message- From: Kevin Faulkner [mailto:[EMAIL PROTECTED] Sent: Wednesday, 24 March 2004 9:14 AM To: CFAussie Mailing List Subject: [cfaussie] regex Hi All, Has anyone any pointers as to the regex for removing all vowels from a string, I know I could do it with 5 normal replaces, but am trying to increase my non-existant regex knowledge. Cheers, Kev --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004 --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004 --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004
[cfaussie] RE: regex....
reReplaceNoCase(someString,'(\S)[aeiou]*','\1','all') should do the trick. -Original Message- From: Kevin Faulkner [mailto:[EMAIL PROTECTED] Sent: Wednesday, 24 March 2004 9:28 AM To: CFAussie Mailing List Subject: [cfaussie] RE: regex Thanks Mina, I was actually just looking into that, but I think abbreviating only replaces vowels that aren't at the start of the word? Could I replace all vowels that aren't either at the start of a string or preceeded by a space? - Original Message - From: Mina Sabag [EMAIL PROTECTED] To: CFAussie Mailing List [EMAIL PROTECTED] Sent: Wednesday, March 24, 2004 10:24 AM Subject: [cfaussie] RE: regex Hi Kevin, Try reReplaceNoCase(someString,'[aeiou]','','all') Regards, Mina Mina Sabag Web Developer E-Commerce Tourism Queensland Looking for accommodation at discount prices? www.BestRates.com.au -Original Message- From: Kevin Faulkner [mailto:[EMAIL PROTECTED] Sent: Wednesday, 24 March 2004 9:14 AM To: CFAussie Mailing List Subject: [cfaussie] regex Hi All, Has anyone any pointers as to the regex for removing all vowels from a string, I know I could do it with 5 normal replaces, but am trying to increase my non-existant regex knowledge. Cheers, Kev --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004 --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004 --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004 --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004
[cfaussie] RE: regex....
Mmm, not quite, this seems to abbreviate all but the first word, but I think I can use this to get exactly what I want though. Thanks again. - Original Message - From: Mina Sabag [EMAIL PROTECTED] To: CFAussie Mailing List [EMAIL PROTECTED] Sent: Wednesday, March 24, 2004 11:44 AM Subject: [cfaussie] RE: regex reReplaceNoCase(someString,'(\S)[aeiou]*','\1','all') should do the trick. -Original Message- From: Kevin Faulkner [mailto:[EMAIL PROTECTED] Sent: Wednesday, 24 March 2004 9:28 AM To: CFAussie Mailing List Subject: [cfaussie] RE: regex Thanks Mina, I was actually just looking into that, but I think abbreviating only replaces vowels that aren't at the start of the word? Could I replace all vowels that aren't either at the start of a string or preceeded by a space? - Original Message - From: Mina Sabag [EMAIL PROTECTED] To: CFAussie Mailing List [EMAIL PROTECTED] Sent: Wednesday, March 24, 2004 10:24 AM Subject: [cfaussie] RE: regex Hi Kevin, Try reReplaceNoCase(someString,'[aeiou]','','all') Regards, Mina Mina Sabag Web Developer E-Commerce Tourism Queensland Looking for accommodation at discount prices? www.BestRates.com.au -Original Message- From: Kevin Faulkner [mailto:[EMAIL PROTECTED] Sent: Wednesday, 24 March 2004 9:14 AM To: CFAussie Mailing List Subject: [cfaussie] regex Hi All, Has anyone any pointers as to the regex for removing all vowels from a string, I know I could do it with 5 normal replaces, but am trying to increase my non-existant regex knowledge. Cheers, Kev --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004 --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004 --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004 --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004 --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004
[cfaussie] RE: regex?
[EMAIL PROTECTED] wrote: I'm trying to extract the number 23 which follows the string Semester: Is this a job for regex? Sure, this should do the trick: cfscript stMatch = REFind(Semester:\s*([1-9]+), s, 1, true); if(stMatch.pos[1] NEQ 0){ for(i = 2; i LTE ArrayLen(stMatch.pos); i = i + 1){ WriteOutput(i : Mid(s, stMatch.pos[i], stMatch.len[i]) br); } } /cfscript -- Lindsay Evans. Developer, Red Square Productions. [p] 8596.4000 [f] 8596.4001 [w] www.redsquare.com.au --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004
[cfaussie] RE: regex?
This is the way I managed to get it to work cfset st = refind(Semester: [0-9]*, cfhttp.fileContent, 0, TRUE) cfdump var=#right(left(cfhttp.fileContent,st.pos[1]+st.len[1]-1),2)# Looks like using the array would be more efficient though... [EMAIL PROTECTED] 01/09/04 05:33am [EMAIL PROTECTED] wrote: I'm trying to extract the number 23 which follows the string Semester: Is this a job for regex? Sure, this should do the trick: cfscript stMatch = REFind(Semester:\s*([1-9]+), s, 1, true); if(stMatch.pos[1] NEQ 0){ for(i = 2; i LTE ArrayLen(stMatch.pos); i = i + 1){ WriteOutput(i : Mid(s, stMatch.pos[i], stMatch.len[i]) br); } } /cfscript -- Lindsay Evans. Developer, Red Square Productions. [p] 8596.4000 [f] 8596.4001 [w] www.redsquare.com.au --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004 --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004
[cfaussie] RE: RegEx in db WAS: XML Searching
How is MySQL progressing? I believe the latest version now supports Stored Procedures, is that correct? If so, do they handle well? And how about triggers? --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004
[cfaussie] Re: RegEx Backreferences...
Something like this should do it for you: cfset regex = (\d+)\s+(\d{4}\s+\d{4}) cfset str = 07 1234 5678 cfset stResult = reFindNoCase(regex,str,1,true) cfdump var=#stResult# cfset areacode = mid(str,stResult.pos[2],stResult.len[2]) cfset number = mid(str,stResult.pos[3],stResult.len[3]) cfoutput(#areacode#) #number#/cfoutput If you return sub-expressions, the resulting structure will contain multiple entries. The first element in the pos and len arrays will be the match for the whole regex. The subsequent entries will be the matches for the sub-expressions. There should be n+1 entries in those arrays. Where n is the number of sub-expressions in your regex. Spike Taco Fleur wrote: Morning! How do I return back references? (maybe I need another coffee, but I just don't see it) The regex (\d+)\s+(\d{4}\s+\d{4}) 07 1234 5678 I know I can reference to the area code by 07 = \1 I know I can reference to the telephone number by 1234 5678 = \2 But how in godsname do I output it? I could NOT just do cfoutput #\1# #\2# /cfoutput All I can think of is using reReplace() but surely there must be some other way!? *Taco Fleur 07 3535 5072* Tell me and I will forget Show me and I will remember Teach me and I will learn --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004 -- Stephen Milligan Software Architect for http://www.bestrates.com.au MSN: [EMAIL PROTECTED] --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004
[cfaussie] Re: RegEx Backreferences...
off course, cheers! -Original Message- From: Spike [mailto:[EMAIL PROTECTED] Sent: Thursday, 20 November 2003 9:41 AM To: CFAussie Mailing List Subject: [cfaussie] Re: RegEx Backreferences... Something like this should do it for you: cfset regex = (\d+)\s+(\d{4}\s+\d{4}) cfset str = 07 1234 5678 cfset stResult = reFindNoCase(regex,str,1,true) cfdump var=#stResult# cfset areacode = mid(str,stResult.pos[2],stResult.len[2]) cfset number = mid(str,stResult.pos[3],stResult.len[3]) cfoutput(#areacode#) #number#/cfoutput If you return sub-expressions, the resulting structure will contain multiple entries. The first element in the pos and len arrays will be the match for the whole regex. The subsequent entries will be the matches for the sub-expressions. There should be n+1 entries in those arrays. Where n is the number of sub-expressions in your regex. Spike Taco Fleur wrote: Morning! How do I return back references? (maybe I need another coffee, but I just don't see it) The regex (\d+)\s+(\d{4}\s+\d{4}) 07 1234 5678 I know I can reference to the area code by 07 = \1 I know I can reference to the telephone number by 1234 5678 = \2 But how in godsname do I output it? I could NOT just do cfoutput #\1# #\2# /cfoutput All I can think of is using reReplace() but surely there must be some other way!? *Taco Fleur 07 3535 5072* Tell me and I will forget Show me and I will remember Teach me and I will learn --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004 -- Stephen Milligan Software Architect for http://www.bestrates.com.au MSN: [EMAIL PROTECTED] --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004 --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004
[cfaussie] Re: RegEx Backreferences...
The example I showed was just an example, really the telephone number could be anything +31 07 3433 3243 07 3433 2111 4345 3434 4455 -Original Message- From: Matthew Walker [mailto:[EMAIL PROTECTED] Sent: Thursday, 20 November 2003 10:25 AM To: CFAussie Mailing List Subject: [cfaussie] Re: RegEx Backreferences... It's so that I know pos[3] will always return the area code. But the area code is the first subexpression starting at pos[2] . . . ? -Original Message- From: [EMAIL PROTECTED] [mailto:bounce-cfaussie- [EMAIL PROTECTED] On Behalf Of Taco Fleur Sent: Thursday, 20 November 2003 11:56 a.m. To: CFAussie Mailing List Subject: [cfaussie] Re: RegEx Backreferences... ok next one... Can you do something like (\+\d+|select nothing here, but populate structure) Reason for doing this is so that pos[2] len[2] will exists, if that makes any sense? It's so that I know pos[3] will always return the area code. -Original Message- From: Spike [mailto:[EMAIL PROTECTED] Sent: Thursday, 20 November 2003 9:41 AM To: CFAussie Mailing List Subject: [cfaussie] Re: RegEx Backreferences... Something like this should do it for you: cfset regex = (\d+)\s+(\d{4}\s+\d{4}) cfset str = 07 1234 5678 cfset stResult = reFindNoCase(regex,str,1,true) cfdump var=#stResult# cfset areacode = mid(str,stResult.pos[2],stResult.len[2]) cfset number = mid(str,stResult.pos[3],stResult.len[3]) cfoutput(#areacode#) #number#/cfoutput If you return sub-expressions, the resulting structure will contain multiple entries. The first element in the pos and len arrays will be the match for the whole regex. The subsequent entries will be the matches for the sub-expressions. There should be n+1 entries in those arrays. Where n is the number of sub-expressions in your regex. Spike Taco Fleur wrote: Morning! How do I return back references? (maybe I need another coffee, but I just don't see it) The regex (\d+)\s+(\d{4}\s+\d{4}) 07 1234 5678 I know I can reference to the area code by 07 = \1 I know I can reference to the telephone number by 1234 5678 = \2 But how in godsname do I output it? I could NOT just do cfoutput #\1# #\2# /cfoutput All I can think of is using reReplace() but surely there must be some other way!? *Taco Fleur 07 3535 5072* Tell me and I will forget Show me and I will remember Teach me and I will learn --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004 -- Stephen Milligan Software Architect for http://www.bestrates.com.au MSN: [EMAIL PROTECTED] --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to leave-cfaussie- [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004 --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to leave-cfaussie- [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004 --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004 --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004
[cfaussie] RE: RegEx..............
Title: RegEx.. How did you go with this Taco? -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Taco FleurSent: Tuesday, November 11, 2003 4:01 PMTo: CFAussie Mailing ListSubject: [cfaussie] RE: RegEx.. "Level 2" "55 Harrington Street" -Original Message-From: Steve Onnis [mailto:[EMAIL PROTECTED]Sent: Tuesday, 11 November 2003 2:57 PMTo: CFAussie Mailing ListSubject: [cfaussie] RE: RegEx.. So what is " Level 2, 55 Harrington Street," suposed to end up looking like? -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Taco FleurSent: Tuesday, November 11, 2003 3:27 PMTo: CFAussie Mailing ListSubject: [cfaussie] RE: RegEx.. yes it should, but it isn't Like I said, I even tried replace [^a-z0-9] i.e. replace anything not alphanumeric, which worked fine except on the problem rows. And it just doesn't make any sense. -Original Message-From: Matthew Walker [mailto:[EMAIL PROTECTED]Sent: Tuesday, 11 November 2003 2:16 PMTo: CFAussie Mailing ListSubject: [cfaussie] RE: RegEx.. So reReplace(address, ^[[:space:],]+, , ALL) should catch the leading spaces and commas, and reReplace(address, [[:space:],]+$ , , ALL) should catch the trailing, right? -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Taco FleurSent: Tuesday, 11 November 2003 4:04 p.m.To: CFAussie Mailing ListSubject: [cfaussie] RE: RegEx.. some of the original strings that I am having issues withlook like " Level 2, 55 Harrington Street," "LEVEL 17, 175 EAGLE ST," "Level 2, 38 York Street" ---You are currently subscribed to cfaussie as: [EMAIL PROTECTED]To unsubscribe send a blank email to [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australiahttp://www.mxdu.com/ + 24-25 February, 2004 ---You are currently subscribed to cfaussie as: [EMAIL PROTECTED]To unsubscribe send a blank email to [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australiahttp://www.mxdu.com/ + 24-25 February, 2004 --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004
[cfaussie] RE: RegEx..............
Title: RegEx.. Sorry Guys, didn't ignore the proposed solutions or anything, just been busy.. I had a look at your proposed solution, but would that not remove the comma fromentries like "Makerston Street , Level 8" as well? --- maybe do a select first thought just to make sure its giving you what you want cfquery name="qSelect" datasource="dsnCCDB_testing"SELECTlevelFloor = RTRIM(LTRIM(LEFT([Street Address 1],PATINDEX('%_,%',[Street Address 1] AS Level, streetAddress1Copy = RTRIM(LTRIM(SUBSTRING([Street Address 1],PATINDEX('%_,%',[Street Address 1])+1,Len([Street Address 1] AS StreetAddress FROM_temp_All_Datasources_Deduped/cfquery --- Anyway, I decided those few records out of the 13.000 will just have be cleansed manually at some stage... .weird though.. Thanks -Original Message-From: Steve Onnis [mailto:[EMAIL PROTECTED]Sent: Wednesday, 12 November 2003 1:54 PMTo: CFAussie Mailing ListSubject: [cfaussie] RE: RegEx.. How did you go with this Taco? -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Taco FleurSent: Tuesday, November 11, 2003 4:01 PMTo: CFAussie Mailing ListSubject: [cfaussie] RE: RegEx.. "Level 2" "55 Harrington Street" -Original Message-From: Steve Onnis [mailto:[EMAIL PROTECTED]Sent: Tuesday, 11 November 2003 2:57 PMTo: CFAussie Mailing ListSubject: [cfaussie] RE: RegEx.. So what is " Level 2, 55 Harrington Street," suposed to end up looking like? -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Taco FleurSent: Tuesday, November 11, 2003 3:27 PMTo: CFAussie Mailing ListSubject: [cfaussie] RE: RegEx.. yes it should, but it isn't Like I said, I even tried replace [^a-z0-9] i.e. replace anything not alphanumeric, which worked fine except on the problem rows. And it just doesn't make any sense. -Original Message-From: Matthew Walker [mailto:[EMAIL PROTECTED]Sent: Tuesday, 11 November 2003 2:16 PMTo: CFAussie Mailing ListSubject: [cfaussie] RE: RegEx.. So reReplace(address, ^[[:space:],]+, , ALL) should catch the leading spaces and commas, and reReplace(address, [[:space:],]+$ , , ALL) should catch the trailing, right? -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Taco FleurSent: Tuesday, 11 November 2003 4:04 p.m.To: CFAussie Mailing ListSubject: [cfaussie] RE: RegEx.. some of the original strings that I am having issues withlook like " Level 2, 55 Harrington Street," "LEVEL 17, 175 EAGLE ST," "Level 2, 38 York Street" ---You are currently subscribed to cfaussie as: [EMAIL PROTECTED]To unsubscribe send a blank email to [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australiahttp://www.mxdu.com/ + 24-25 February, 2004 ---You are currently subscribed to cfaussie as: [EMAIL PROTECTED]To unsubscribe send a blank email to [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australiahttp://www.mxdu.com/ + 24-25 February, 2004 ---You are currently subscribed to cfaussie as: [EMAIL PROTECTED]To unsubscribe send a blank email to [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australiahttp://www.mxdu.com/ + 24-25 February, 2004 --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004
[cfaussie] RE: RegEx..............
Title: RegEx.. If your putting the values into seperate columns, why would you want to keep the comma anyway? -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Taco FleurSent: Wednesday, November 12, 2003 3:30 PMTo: CFAussie Mailing ListSubject: [cfaussie] RE: RegEx.. Sorry Guys, didn't ignore the proposed solutions or anything, just been busy.. I had a look at your proposed solution, but would that not remove the comma fromentries like "Makerston Street , Level 8" as well? --- maybe do a select first thought just to make sure its giving you what you want cfquery name="qSelect" datasource="dsnCCDB_testing"SELECTlevelFloor = RTRIM(LTRIM(LEFT([Street Address 1],PATINDEX('%_,%',[Street Address 1] AS Level, streetAddress1Copy = RTRIM(LTRIM(SUBSTRING([Street Address 1],PATINDEX('%_,%',[Street Address 1])+1,Len([Street Address 1] AS StreetAddress FROM_temp_All_Datasources_Deduped/cfquery --- Anyway, I decided those few records out of the 13.000 will just have be cleansed manually at some stage... .weird though.. Thanks -Original Message-From: Steve Onnis [mailto:[EMAIL PROTECTED]Sent: Wednesday, 12 November 2003 1:54 PMTo: CFAussie Mailing ListSubject: [cfaussie] RE: RegEx.. How did you go with this Taco? -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Taco FleurSent: Tuesday, November 11, 2003 4:01 PMTo: CFAussie Mailing ListSubject: [cfaussie] RE: RegEx.. "Level 2" "55 Harrington Street" -Original Message-From: Steve Onnis [mailto:[EMAIL PROTECTED]Sent: Tuesday, 11 November 2003 2:57 PMTo: CFAussie Mailing ListSubject: [cfaussie] RE: RegEx.. So what is " Level 2, 55 Harrington Street," suposed to end up looking like? -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Taco FleurSent: Tuesday, November 11, 2003 3:27 PMTo: CFAussie Mailing ListSubject: [cfaussie] RE: RegEx.. yes it should, but it isn't Like I said, I even tried replace [^a-z0-9] i.e. replace anything not alphanumeric, which worked fine except on the problem rows. And it just doesn't make any sense. -Original Message-From: Matthew Walker [mailto:[EMAIL PROTECTED]Sent: Tuesday, 11 November 2003 2:16 PMTo: CFAussie Mailing ListSubject: [cfaussie] RE: RegEx.. So reReplace(address, ^[[:space:],]+, , ALL) should catch the leading spaces and commas, and reReplace(address, [[:space:],]+$ , , ALL) should catch the trailing, right? -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Taco FleurSent: Tuesday, 11 November 2003 4:04 p.m.To: CFAussie Mailing ListSubject: [cfaussie] RE: RegEx.. some of the original strings that I am having issues withlook like " Level 2, 55 Harrington Street," "LEVEL 17, 175 EAGLE ST," "Level 2, 38 York Street" ---You are currently subscribed to cfaussie as: [EMAIL PROTECTED]To unsubscribe send a blank email to [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australiahttp://www.mxdu.com/ + 24-25 February, 2004 ---You are currently subscribed to cfaussie as: [EMAIL PROTECTED]To unsubscribe send a blank email to [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australiahttp://www.mxdu.com/ + 24-25 February, 2004 ---You are currently subscribed to cfaussie as: [EMAIL PROTECTED]To unsubscribe send a blank email to [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australiahttp://www.mxdu.com/ + 24-25 February, 2004 ---You are currently subscribed to cfaussie as: [EMAIL PROTECTED]To unsubscribe send a blank email to [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australiahttp://www.mxdu.com/ + 24-25 February
[cfaussie] RE: RegEx..............
Title: RegEx.. Correct, I showed a bad example "Annexe building, George Street, Level 3" -Original Message-From: Steve Onnis [mailto:[EMAIL PROTECTED]Sent: Wednesday, 12 November 2003 2:38 PMTo: CFAussie Mailing ListSubject: [cfaussie] RE: RegEx.. If your putting the values into seperate columns, why would you want to keep the comma anyway? -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Taco FleurSent: Wednesday, November 12, 2003 3:30 PMTo: CFAussie Mailing ListSubject: [cfaussie] RE: RegEx.. Sorry Guys, didn't ignore the proposed solutions or anything, just been busy.. I had a look at your proposed solution, but would that not remove the comma fromentries like "Makerston Street , Level 8" as well? --- maybe do a select first thought just to make sure its giving you what you want cfquery name="qSelect" datasource="dsnCCDB_testing"SELECTlevelFloor = RTRIM(LTRIM(LEFT([Street Address 1],PATINDEX('%_,%',[Street Address 1] AS Level, streetAddress1Copy = RTRIM(LTRIM(SUBSTRING([Street Address 1],PATINDEX('%_,%',[Street Address 1])+1,Len([Street Address 1] AS StreetAddress FROM_temp_All_Datasources_Deduped/cfquery --- Anyway, I decided those few records out of the 13.000 will just have be cleansed manually at some stage... .weird though.. Thanks -Original Message-From: Steve Onnis [mailto:[EMAIL PROTECTED]Sent: Wednesday, 12 November 2003 1:54 PMTo: CFAussie Mailing ListSubject: [cfaussie] RE: RegEx.. How did you go with this Taco? -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Taco FleurSent: Tuesday, November 11, 2003 4:01 PMTo: CFAussie Mailing ListSubject: [cfaussie] RE: RegEx.. "Level 2" "55 Harrington Street" -Original Message-From: Steve Onnis [mailto:[EMAIL PROTECTED]Sent: Tuesday, 11 November 2003 2:57 PMTo: CFAussie Mailing ListSubject: [cfaussie] RE: RegEx.. So what is " Level 2, 55 Harrington Street," suposed to end up looking like? -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Taco FleurSent: Tuesday, November 11, 2003 3:27 PMTo: CFAussie Mailing ListSubject: [cfaussie] RE: RegEx.. yes it should, but it isn't Like I said, I even tried replace [^a-z0-9] i.e. replace anything not alphanumeric, which worked fine except on the problem rows. And it just doesn't make any sense. -Original Message-From: Matthew Walker [mailto:[EMAIL PROTECTED]Sent: Tuesday, 11 November 2003 2:16 PMTo: CFAussie Mailing ListSubject: [cfaussie] RE: RegEx.. So reReplace(address, ^[[:space:],]+, , ALL) should catch the leading spaces and commas, and reReplace(address, [[:space:],]+$ , , ALL) should catch the trailing, right? -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Taco FleurSent: Tuesday, 11 November 2003 4:04 p.m.To: CFAussie Mailing ListSubject: [cfaussie] RE: RegEx.. some of the original strings that I am having issues withlook like " Level 2, 55 Harrington Street," "LEVEL 17, 175 EAGLE ST," "Level 2, 38 York Street" ---You are currently subscribed to cfaussie as: [EMAIL PROTECTED]To unsubscribe send a blank email to [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australiahttp://www.mxdu.com/ + 24-25 February, 2004 ---You are currently subscribed to cfaussie as: [EMAIL PROTECTED]To unsubscribe send a blank email to [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon
[cfaussie] RE: RegEx..............
Title: RegEx.. so that would leave you with one value of "Annexe building" and another of"George Street, Level 3" With ones like that you would be wanting "Level 3 Annexe building" and "George Street". Your gonna have to manually get those ones out. -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Taco FleurSent: Wednesday, November 12, 2003 3:46 PMTo: CFAussie Mailing ListSubject: [cfaussie] RE: RegEx.. Correct, I showed a bad example "Annexe building, George Street, Level 3" -Original Message-From: Steve Onnis [mailto:[EMAIL PROTECTED]Sent: Wednesday, 12 November 2003 2:38 PMTo: CFAussie Mailing ListSubject: [cfaussie] RE: RegEx.. If your putting the values into seperate columns, why would you want to keep the comma anyway? -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Taco FleurSent: Wednesday, November 12, 2003 3:30 PMTo: CFAussie Mailing ListSubject: [cfaussie] RE: RegEx.. Sorry Guys, didn't ignore the proposed solutions or anything, just been busy.. I had a look at your proposed solution, but would that not remove the comma fromentries like "Makerston Street , Level 8" as well? --- maybe do a select first thought just to make sure its giving you what you want cfquery name="qSelect" datasource="dsnCCDB_testing"SELECTlevelFloor = RTRIM(LTRIM(LEFT([Street Address 1],PATINDEX('%_,%',[Street Address 1] AS Level, streetAddress1Copy = RTRIM(LTRIM(SUBSTRING([Street Address 1],PATINDEX('%_,%',[Street Address 1])+1,Len([Street Address 1] AS StreetAddress FROM_temp_All_Datasources_Deduped/cfquery --- Anyway, I decided those few records out of the 13.000 will just have be cleansed manually at some stage... .weird though.. Thanks -Original Message-From: Steve Onnis [mailto:[EMAIL PROTECTED]Sent: Wednesday, 12 November 2003 1:54 PMTo: CFAussie Mailing ListSubject: [cfaussie] RE: RegEx.. How did you go with this Taco? -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Taco FleurSent: Tuesday, November 11, 2003 4:01 PMTo: CFAussie Mailing ListSubject: [cfaussie] RE: RegEx.. "Level 2" "55 Harrington Street" -Original Message-From: Steve Onnis [mailto:[EMAIL PROTECTED]Sent: Tuesday, 11 November 2003 2:57 PMTo: CFAussie Mailing ListSubject: [cfaussie] RE: RegEx.. So what is " Level 2, 55 Harrington Street," suposed to end up looking like? -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Taco FleurSent: Tuesday, November 11, 2003 3:27 PMTo: CFAussie Mailing ListSubject: [cfaussie] RE: RegEx.. yes it should, but it isn't Like I said, I even tried replace [^a-z0-9] i.e. replace anything not alphanumeric, which worked fine except on the problem rows. And it just doesn't make any sense. -Original Message-From: Matthew Walker [mailto:[EMAIL PROTECTED]Sent: Tuesday, 11 November 2003 2:16 PMTo: CFAussie Mailing ListSubject: [cfaussie] RE: RegEx.. So reReplace(address, ^[[:space:],]+, , ALL) should catch the leading spaces and commas, and reReplace(address, [[:space:],]+$ , , ALL) should catch the trailing, right? -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Taco FleurSent: Tuesday, 11 November 2003 4:04 p.m.To: CFAussie Mailing ListSubject: [cfaussie] RE: RegEx.. some of the original strings that I am having issues withlook like
[cfaussie] RE: RegEx..............
Title: RegEx.. How about reReplace(address, (^[[:space:],]+|[[:space:],]+$), , ALL) ? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Taco Fleur Sent: Tuesday, 11 November 2003 2:24 p.m. To: CFAussie Mailing List Subject: [cfaussie] RegEx.. I have this RegEx cfset regEx = \s*\d*\s*(th|rd|nd|st)\s*(floor|level|lvl)|\s*(ground (floor|level))|\s*(floor|level)\s*\d* It is extracting LEVEL and FLOOR information from 13.000 addresses, it works fine. but When I insert the remaining ADDRESS part after the floor level extraction I end up with records like , Lamington National Park Road , Lamington National Park Road , I run an extra regex reReplace on inserting the new address field, which is (\s*,)|($\s,)|$,|^\s But it doesn't do any good, I still end up with the records formatted like above. Anyone? Taco Fleur 07 3535 5072 Tell me and I will forget Show me and I will remember Teach me and I will learn --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004 --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004
[cfaussie] RE: RegEx..............
Title: RegEx.. Nope, I still get entries like ", 55 Harrington Street" ", 80 William St " "1 Eagle Street," I ran a regex on the string before, one that deletes everything but a-z0-9 and even that left the space and comma in there, that's when I consulted this list... Like it did work for most records but never for the same records... ??? -Original Message-From: Matthew Walker [mailto:[EMAIL PROTECTED]Sent: Tuesday, 11 November 2003 12:34 PMTo: CFAussie Mailing ListSubject: [cfaussie] RE: RegEx.. How about reReplace(address, (^[[:space:],]+|[[:space:],]+$), , ALL) ? -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Taco FleurSent: Tuesday, 11 November 2003 2:24 p.m.To: CFAussie Mailing ListSubject: [cfaussie] RegEx.. I have this RegEx cfset regEx = "\s*\d*\s*(th|rd|nd|st)\s*(floor|level|lvl)|\s*(ground (floor|level))|\s*(floor|level)\s*\d*" It is extracting LEVEL and FLOOR information from 13.000 addresses, it works fine. but When I insert the remaining ADDRESS part after the floor level extraction I end up with records like " , Lamington National Park Road " ", Lamington National Park Road , " I run an extra regex reReplace on inserting the new address field, which is (\s*,)|($\s,)|$,|^\s But it doesn't do any good, I still end up with the records formatted like above. Anyone? Taco Fleur07 3535 5072 Tell me and I will forgetShow me and I will rememberTeach me and I will learn ---You are currently subscribed to cfaussie as: [EMAIL PROTECTED]To unsubscribe send a blank email to [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australiahttp://www.mxdu.com/ + 24-25 February, 2004 ---You are currently subscribed to cfaussie as: [EMAIL PROTECTED]To unsubscribe send a blank email to [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australiahttp://www.mxdu.com/ + 24-25 February, 2004 --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004
[cfaussie] RE: RegEx..............
Title: RegEx.. I loop over 13.000 records... yeah I know, but how in godsname do you do a regex in MS SQL? I haven't found how yet, if there is a HOW Maybe it could be done by working with SPs and call some objects, but I haven't figured out how yet... ;-)) -Original Message-From: Matthew Walker [mailto:[EMAIL PROTECTED]Sent: Tuesday, 11 November 2003 1:01 PMTo: CFAussie Mailing ListSubject: [cfaussie] RE: RegEx.. Are you applying the regex to lots of strings like ", 55 Harrington Street" or to one big string with lots of entries? -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Taco FleurSent: Tuesday, 11 November 2003 2:53 p.m.To: CFAussie Mailing ListSubject: [cfaussie] RE: RegEx.. Nope, I still get entries like ", 55 Harrington Street" ", 80 William St " "1 Eagle Street," I ran a regex on the string before, one that deletes everything but a-z0-9 and even that left the space and comma in there, that's when I consulted this list... Like it did work for most records but never for the same records... ??? -Original Message-From: Matthew Walker [mailto:[EMAIL PROTECTED]Sent: Tuesday, 11 November 2003 12:34 PMTo: CFAussie Mailing ListSubject: [cfaussie] RE: RegEx.. How about reReplace(address, (^[[:space:],]+|[[:space:],]+$), , ALL) ? -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Taco FleurSent: Tuesday, 11 November 2003 2:24 p.m.To: CFAussie Mailing ListSubject: [cfaussie] RegEx.. I have this RegEx cfset regEx = "\s*\d*\s*(th|rd|nd|st)\s*(floor|level|lvl)|\s*(ground (floor|level))|\s*(floor|level)\s*\d*" It is extracting LEVEL and FLOOR information from 13.000 addresses, it works fine. but When I insert the remaining ADDRESS part after the floor level extraction I end up with records like " , Lamington National Park Road " ", Lamington National Park Road , " I run an extra regex reReplace on inserting the new address field, which is (\s*,)|($\s,)|$,|^\s But it doesn't do any good, I still end up with the records formatted like above. Anyone? Taco Fleur07 3535 5072 Tell me and I will forgetShow me and I will rememberTeach me and I will learn ---You are currently subscribed to cfaussie as: [EMAIL PROTECTED]To unsubscribe send a blank email to [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australiahttp://www.mxdu.com/ + 24-25 February, 2004 ---You are currently subscribed to cfaussie as: [EMAIL PROTECTED]To unsubscribe send a blank email to [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australiahttp://www.mxdu.com/ + 24-25 February, 2004 ---You are currently subscribed to cfaussie as: [EMAIL PROTECTED]To unsubscribe send a blank email to [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australiahttp://www.mxdu.com/ + 24-25 February, 2004 ---You are currently subscribed to cfaussie as: [EMAIL PROTECTED]To unsubscribe send a blank email to [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australiahttp://www.mxdu.com/ + 24-25 February, 2004 --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004
[cfaussie] RE: RegEx..............
Title: RegEx.. What does an original string look like? -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Taco FleurSent: Tuesday, November 11, 2003 2:20 PMTo: CFAussie Mailing ListSubject: [cfaussie] RE: RegEx.. I loop over 13.000 records... yeah I know, but how in godsname do you do a regex in MS SQL? I haven't found how yet, if there is a HOW Maybe it could be done by working with SPs and call some objects, but I haven't figured out how yet... ;-)) -Original Message-From: Matthew Walker [mailto:[EMAIL PROTECTED]Sent: Tuesday, 11 November 2003 1:01 PMTo: CFAussie Mailing ListSubject: [cfaussie] RE: RegEx.. Are you applying the regex to lots of strings like ", 55 Harrington Street" or to one big string with lots of entries? -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Taco FleurSent: Tuesday, 11 November 2003 2:53 p.m.To: CFAussie Mailing ListSubject: [cfaussie] RE: RegEx.. Nope, I still get entries like ", 55 Harrington Street" ", 80 William St " "1 Eagle Street," I ran a regex on the string before, one that deletes everything but a-z0-9 and even that left the space and comma in there, that's when I consulted this list... Like it did work for most records but never for the same records... ??? -Original Message-From: Matthew Walker [mailto:[EMAIL PROTECTED]Sent: Tuesday, 11 November 2003 12:34 PMTo: CFAussie Mailing ListSubject: [cfaussie] RE: RegEx.. How about reReplace(address, (^[[:space:],]+|[[:space:],]+$), , ALL) ? -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Taco FleurSent: Tuesday, 11 November 2003 2:24 p.m.To: CFAussie Mailing ListSubject: [cfaussie] RegEx.. I have this RegEx cfset regEx = "\s*\d*\s*(th|rd|nd|st)\s*(floor|level|lvl)|\s*(ground (floor|level))|\s*(floor|level)\s*\d*" It is extracting LEVEL and FLOOR information from 13.000 addresses, it works fine. but When I insert the remaining ADDRESS part after the floor level extraction I end up with records like " , Lamington National Park Road " ", Lamington National Park Road , " I run an extra regex reReplace on inserting the new address field, which is (\s*,)|($\s,)|$,|^\s But it doesn't do any good, I still end up with the records formatted like above. Anyone? Taco Fleur07 3535 5072 Tell me and I will forgetShow me and I will rememberTeach me and I will learn ---You are currently subscribed to cfaussie as: [EMAIL PROTECTED]To unsubscribe send a blank email to [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australiahttp://www.mxdu.com/ + 24-25 February, 2004 ---You are currently subscribed to cfaussie as: [EMAIL PROTECTED]To unsubscribe send a blank email to [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australiahttp://www.mxdu.com/ + 24-25 February, 2004 ---You are currently subscribed to cfaussie as: [EMAIL PROTECTED]To unsubscribe send a blank email to [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australiahttp://www.mxdu.com/ + 24-25 February, 2004 ---You are currently subscribed to cfaussie as: [EMAIL PROTECTED]To unsubscribe send a blank email to [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australiahttp://www.mxdu.com/ + 24-25 February, 2004 ---You are currently subscribed to cfaussie as: [EMAIL PROTECTED]To unsubscribe send a blank email to [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australiahttp://www.mxdu.com/ + 24-25 February, 2004 --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004
[cfaussie] RE: RegEx..............
Title: RegEx.. some of the original strings that I am having issues withlook like " Level 2, 55 Harrington Street," "LEVEL 17, 175 EAGLE ST," "Level 2, 38 York Street" -Original Message-From: Steve Onnis [mailto:[EMAIL PROTECTED]Sent: Tuesday, 11 November 2003 1:46 PMTo: CFAussie Mailing ListSubject: [cfaussie] RE: RegEx.. What does an original string look like? -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Taco FleurSent: Tuesday, November 11, 2003 2:20 PMTo: CFAussie Mailing ListSubject: [cfaussie] RE: RegEx.. I loop over 13.000 records... yeah I know, but how in godsname do you do a regex in MS SQL? I haven't found how yet, if there is a HOW Maybe it could be done by working with SPs and call some objects, but I haven't figured out how yet... ;-)) -Original Message-From: Matthew Walker [mailto:[EMAIL PROTECTED]Sent: Tuesday, 11 November 2003 1:01 PMTo: CFAussie Mailing ListSubject: [cfaussie] RE: RegEx.. Are you applying the regex to lots of strings like ", 55 Harrington Street" or to one big string with lots of entries? -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Taco FleurSent: Tuesday, 11 November 2003 2:53 p.m.To: CFAussie Mailing ListSubject: [cfaussie] RE: RegEx.. Nope, I still get entries like ", 55 Harrington Street" ", 80 William St " "1 Eagle Street," I ran a regex on the string before, one that deletes everything but a-z0-9 and even that left the space and comma in there, that's when I consulted this list... Like it did work for most records but never for the same records... ??? -Original Message-From: Matthew Walker [mailto:[EMAIL PROTECTED]Sent: Tuesday, 11 November 2003 12:34 PMTo: CFAussie Mailing ListSubject: [cfaussie] RE: RegEx.. How about reReplace(address, (^[[:space:],]+|[[:space:],]+$), , ALL) ? -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Taco FleurSent: Tuesday, 11 November 2003 2:24 p.m.To: CFAussie Mailing ListSubject: [cfaussie] RegEx.. I have this RegEx cfset regEx = "\s*\d*\s*(th|rd|nd|st)\s*(floor|level|lvl)|\s*(ground (floor|level))|\s*(floor|level)\s*\d*" It is extracting LEVEL and FLOOR information from 13.000 addresses, it works fine. but When I insert the remaining ADDRESS part after the floor level extraction I end up with records like " , Lamington National Park Road " ", Lamington National Park Road , " I run an extra regex reReplace on inserting the new address field, which is (\s*,)|($\s,)|$,|^\s But it doesn't do any good, I still end up with the records formatted like above. Anyone? Taco Fleur07 3535 5072 Tell me and I will forgetShow me and I will rememberTeach me and I will learn ---You are currently subscribed to cfaussie as: [EMAIL PROTECTED]To unsubscribe send a blank email to [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australiahttp://www.mxdu.com/ + 24-25 February, 2004 ---You are currently subscribed to cfaussie as: [EMAIL PROTECTED]To unsubscribe send a blank email to [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australiahttp://www.mxdu.com/ + 24-25 February, 2004 ---You are currently subscribed to cfaussie as: [EMAIL PROTECTED]To unsubscribe send a blank email to [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australiahttp://www.mxdu.com/ + 24-25 February, 2004 ---You are currently subscribed to cfaussie as: [EMAIL PROTECTED]To unsubscribe send a blank email to [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australiahttp://www.mxdu.com/ + 24-25 February, 2004 ---You are currently subscribed to cfaussie as: [EMAIL PROTECTED]To unsubscribe send a blank email to [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australiahttp://www.mxd
[cfaussie] RE: RegEx..............
Title: RegEx.. So reReplace(address, ^[[:space:],]+, , ALL) should catch the leading spaces and commas, and reReplace(address, [[:space:],]+$ , , ALL) should catch the trailing, right? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Taco Fleur Sent: Tuesday, 11 November 2003 4:04 p.m. To: CFAussie Mailing List Subject: [cfaussie] RE: RegEx.. some of the original strings that I am having issues withlook like Level 2, 55 Harrington Street, LEVEL 17, 175 EAGLE ST, Level 2, 38 York Street -Original Message- From: Steve Onnis [mailto:[EMAIL PROTECTED] Sent: Tuesday, 11 November 2003 1:46 PM To: CFAussie Mailing List Subject: [cfaussie] RE: RegEx.. What does an original string look like? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Taco Fleur Sent: Tuesday, November 11, 2003 2:20 PM To: CFAussie Mailing List Subject: [cfaussie] RE: RegEx.. I loop over 13.000 records... yeah I know, but how in godsname do you do a regex in MS SQL? I haven't found how yet, if there is a HOW Maybe it could be done by working with SPs and call some objects, but I haven't figured out how yet... ;-)) -Original Message- From: Matthew Walker [mailto:[EMAIL PROTECTED] Sent: Tuesday, 11 November 2003 1:01 PM To: CFAussie Mailing List Subject: [cfaussie] RE: RegEx.. Are you applying the regex to lots of strings like , 55 Harrington Street or to one big string with lots of entries? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Taco Fleur Sent: Tuesday, 11 November 2003 2:53 p.m. To: CFAussie Mailing List Subject: [cfaussie] RE: RegEx.. Nope, I still get entries like , 55 Harrington Street , 80 William St 1 Eagle Street, I ran a regex on the string before, one that deletes everything but a-z0-9 and even that left the space and comma in there, that's when I consulted this list... Like it did work for most records but never for the same records... ??? -Original Message- From: Matthew Walker [mailto:[EMAIL PROTECTED] Sent: Tuesday, 11 November 2003 12:34 PM To: CFAussie Mailing List Subject: [cfaussie] RE: RegEx.. How about reReplace(address, (^[[:space:],]+|[[:space:],]+$), , ALL) ? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Taco Fleur Sent: Tuesday, 11 November 2003 2:24 p.m. To: CFAussie Mailing List Subject: [cfaussie] RegEx.. I have this RegEx cfset regEx = \s*\d*\s*(th|rd|nd|st)\s*(floor|level|lvl)|\s*(ground (floor|level))|\s*(floor|level)\s*\d* It is extracting LEVEL and FLOOR information from 13.000 addresses, it works fine. but When I insert the remaining ADDRESS part after the floor level extraction I end up with records like , Lamington National Park Road , Lamington National Park Road , I run an extra regex reReplace on inserting the new address field, which is (\s*,)|($\s,)|$,|^\s But it doesn't do any good, I still end up with the records formatted like above. Anyone? Taco Fleur 07 3535 5072 Tell me and I will forget Show me and I will remember Teach me and I will learn --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004 --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004 --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004 --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004 --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004 --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004 --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February
[cfaussie] RE: RegEx..............
Title: RegEx.. yes it should, but it isn't Like I said, I even tried replace [^a-z0-9] i.e. replace anything not alphanumeric, which worked fine except on the problem rows. And it just doesn't make any sense. -Original Message-From: Matthew Walker [mailto:[EMAIL PROTECTED]Sent: Tuesday, 11 November 2003 2:16 PMTo: CFAussie Mailing ListSubject: [cfaussie] RE: RegEx.. So reReplace(address, ^[[:space:],]+, , ALL) should catch the leading spaces and commas, and reReplace(address, [[:space:],]+$ , , ALL) should catch the trailing, right? -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Taco FleurSent: Tuesday, 11 November 2003 4:04 p.m.To: CFAussie Mailing ListSubject: [cfaussie] RE: RegEx.. some of the original strings that I am having issues withlook like " Level 2, 55 Harrington Street," "LEVEL 17, 175 EAGLE ST," "Level 2, 38 York Street" -Original Message-From: Steve Onnis [mailto:[EMAIL PROTECTED]Sent: Tuesday, 11 November 2003 1:46 PMTo: CFAussie Mailing ListSubject: [cfaussie] RE: RegEx.. What does an original string look like? -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Taco FleurSent: Tuesday, November 11, 2003 2:20 PMTo: CFAussie Mailing ListSubject: [cfaussie] RE: RegEx.. I loop over 13.000 records... yeah I know, but how in godsname do you do a regex in MS SQL? I haven't found how yet, if there is a HOW Maybe it could be done by working with SPs and call some objects, but I haven't figured out how yet... ;-)) -Original Message-From: Matthew Walker [mailto:[EMAIL PROTECTED]Sent: Tuesday, 11 November 2003 1:01 PMTo: CFAussie Mailing ListSubject: [cfaussie] RE: RegEx.. Are you applying the regex to lots of strings like ", 55 Harrington Street" or to one big string with lots of entries? -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Taco FleurSent: Tuesday, 11 November 2003 2:53 p.m.To: CFAussie Mailing ListSubject: [cfaussie] RE: RegEx.. Nope, I still get entries like ", 55 Harrington Street" ", 80 William St " "1 Eagle Street," I ran a regex on the string before, one that deletes everything but a-z0-9 and even that left the space and comma in there, that's when I consulted this list... Like it did work for most records but never for the same records... ??? -Original Message-From: Matthew Walker [mailto:[EMAIL PROTECTED]Sent: Tuesday, 11 November 2003 12:34 PMTo: CFAussie Mailing ListSubject: [cfaussie] RE: RegEx.. How about reReplace(address, (^[[:space:],]+|[[:space:],]+$), , ALL) ? -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Taco FleurSent: Tuesday, 11 November 2003 2:24 p.m.To: CFAussie Mailing ListSubject: [cfaussie] RegEx.. I have this RegEx cfset regEx = "\s*\d*\s*(th|rd|nd|st)\s*(floor|level|lvl)|\s*(ground (floor|level))|\s*(floor|level)\s*\d*" It is extracting LEVEL and FLOOR information from 13.000 addresses, it works fine. but When I insert the remaining ADDRESS part after the floor level extraction I end up with records like " , Lamington National Park Road " ", Lamington National Park Road , " I run an extra regex reReplace on inserting the new address field, which is (\s*,)|($\s,)|$,|^\s But it doesn't do any good, I still end up with the records formatted like above. Anyone? Taco Fleur07 3535 5072 Tell me and I will forgetShow me and I will rememberTeach me and I will learn ---You are currently subscribe
[cfaussie] RE: RegEx..............
Title: RegEx.. cfsetting requesttimeout="800" cfquery name="qOrganisation" datasource="dsnCCDB_testing"SELECT[Street Address 1] AS addressline1, TempIDFROM_temp_All_Datasources_DedupedWHERE(NOT ([Street Address 1] IS NULL)) AND (levelFloor IS NULL)ORDER BY [Street Address 1]/cfquery cfset regEx = "\s*\d*\s*(th|rd|nd|st)\s*(floor|level|lvl)|\s*(ground (floor|level))|\s*(floor|level)\s*\d*" cfloop query="qOrganisation" cfset found = refindNocase(variables.regEx, qOrganisation.Addressline1, 1, "true") !--- a bit messy ---cfset address = trim(reReplaceNoCase(qOrganisation.Addressline1, variables.regEx, ""))cfset address = trim(reReplaceNoCase(trim(variables.address), "(^[[:space:],]+|[[:space:],]+$)", "")) cftrycfquery name="qInsert" datasource="dsnCCDB_testing"UPDATE_temp_All_Datasources_DedupedSETlevelFloor = '#lcase(trim(mid(qOrganisation.Addressline1, found.pos[1], found.len[1])))#', streetAddress1Copy = '#variables.address#'WHERE(TempID = #qOrganisation.TempID#)/cfquerycfcatch/cfcatch/cftry /cfloop --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004
[cfaussie] RE: RegEx..............
Title: RegEx.. "Level 2" "55 Harrington Street" -Original Message-From: Steve Onnis [mailto:[EMAIL PROTECTED]Sent: Tuesday, 11 November 2003 2:57 PMTo: CFAussie Mailing ListSubject: [cfaussie] RE: RegEx.. So what is " Level 2, 55 Harrington Street," suposed to end up looking like? -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Taco FleurSent: Tuesday, November 11, 2003 3:27 PMTo: CFAussie Mailing ListSubject: [cfaussie] RE: RegEx.. yes it should, but it isn't Like I said, I even tried replace [^a-z0-9] i.e. replace anything not alphanumeric, which worked fine except on the problem rows. And it just doesn't make any sense. -Original Message-From: Matthew Walker [mailto:[EMAIL PROTECTED]Sent: Tuesday, 11 November 2003 2:16 PMTo: CFAussie Mailing ListSubject: [cfaussie] RE: RegEx.. So reReplace(address, ^[[:space:],]+, , ALL) should catch the leading spaces and commas, and reReplace(address, [[:space:],]+$ , , ALL) should catch the trailing, right? -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Taco FleurSent: Tuesday, 11 November 2003 4:04 p.m.To: CFAussie Mailing ListSubject: [cfaussie] RE: RegEx.. some of the original strings that I am having issues withlook like " Level 2, 55 Harrington Street," "LEVEL 17, 175 EAGLE ST," "Level 2, 38 York Street" ---You are currently subscribed to cfaussie as: [EMAIL PROTECTED]To unsubscribe send a blank email to [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australiahttp://www.mxdu.com/ + 24-25 February, 2004 --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004
[cfaussie] RE: RegEx..............
Title: RegEx.. Try adding ,all to your rereplace parameters. Default behaviour is just one replacement. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Taco Fleur Sent: Tuesday, 11 November 2003 4:58 p.m. To: CFAussie Mailing List Subject: [cfaussie] RE: RegEx.. cfsetting requesttimeout=800 cfquery name=qOrganisation datasource=dsnCCDB_testing SELECT[Street Address 1] AS addressline1, TempID FROM_temp_All_Datasources_Deduped WHERE(NOT ([Street Address 1] IS NULL)) AND (levelFloor IS NULL) ORDER BY [Street Address 1] /cfquery cfset regEx = \s*\d*\s*(th|rd|nd|st)\s*(floor|level|lvl)|\s*(ground (floor|level))|\s*(floor|level)\s*\d* cfloop query=qOrganisation cfset found = refindNocase(variables.regEx, qOrganisation.Addressline1, 1, true) !--- a bit messy --- cfset address = trim(reReplaceNoCase(qOrganisation.Addressline1, variables.regEx, )) cfset address = trim(reReplaceNoCase(trim(variables.address), (^[[:space:],]+|[[:space:],]+$), )) cftry cfquery name=qInsert datasource=dsnCCDB_testing UPDATE_temp_All_Datasources_Deduped SETlevelFloor = '#lcase(trim(mid(qOrganisation.Addressline1, found.pos[1], found.len[1])))#', streetAddress1Copy = '#variables.address#' WHERE(TempID = #qOrganisation.TempID#) /cfquery cfcatch/cfcatch /cftry /cfloop --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004 --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004
[cfaussie] RE: RegEx in DreamWeaver
Title: Message I'd like it to return a href="" so I can then replace a href="" with a href=""index.cfm/page.application")#" Which I figured would be a href"#urlSessionFormat("$1")#" -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Steve OnnisSent: Thursday, 26 June 2003 5:48 PMTo: CFAussie Mailing ListSubject: [cfaussie] RE: RegEx in DreamWeaver What are you wanting it to return? -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Taco FleurSent: Thursday, June 26, 2003 5:41 PMTo: CFAussie Mailing ListSubject: [cfaussie] RegEx in DreamWeaver I am using a regex to find a string in DreamWeaver and I thought a href=""]" Would return: a href="" but instead it returns: a href="" class="more"More../anbsp;span class="raque"raquo;/span/p/td Is my regex wrong or any otherideas?---You are currently subscribed to cfaussie as: [EMAIL PROTECTED]To unsubscribe send a blank email to [EMAIL PROTECTED]MX Downunder AsiaPac DevCon - http://mxdu.com/ ---You are currently subscribed to cfaussie as: [EMAIL PROTECTED]To unsubscribe send a blank email to [EMAIL PROTECTED]MX Downunder AsiaPac DevCon - http://mxdu.com/ --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MX Downunder AsiaPac DevCon - http://mxdu.com/
[cfaussie] RE: RegEx in DreamWeaver
Perfect, Thanks that was it... I thought it would halt at the first double quote as I have [^] ??? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Lindsay Evans Sent: Thursday, 26 June 2003 6:01 PM To: CFAussie Mailing List Subject: [cfaussie] RE: RegEx in DreamWeaver The RegEx will match the first one, as it is matching any character (except for line breaks, I believe) any number of times. This would probably be a better way to go: a href=([^]*) Which matches any character that *isn't* a double quote any number of times. HTH -- Lindsay Evans. Developer, Red Square Productions. [p] 8596.4000 [f] 8596.4001 [w] www.redsquare.com.au -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Taco Fleur Sent: Thursday, June 26, 2003 5:41 PM To: CFAussie Mailing List Subject: [cfaussie] RegEx in DreamWeaver I am using a regex to find a string in DreamWeaver and I thought a href=(.*)[^] Would return: a href=index.cfm/page.application but instead it returns: a href=index.cfm/page.application class=moreMore../anbsp;span class=raqueraquo;/span/p/td Is my regex wrong or any other ideas? --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MX Downunder AsiaPac DevCon - http://mxdu.com/ --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MX Downunder AsiaPac DevCon - http://mxdu.com/ --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MX Downunder AsiaPac DevCon - http://mxdu.com/
[cfaussie] RE: RegEx in DreamWeaver
yeah, that's a tricky one. What your first RegEx was doing is the equivalent of saying: Match any number of characters (except for newlines), followed by any character that isn't a double quote. The first pattern will (usually) be matched first, then the RegEx engine will start all over again until it finds any character that is a line break (I think there may be more to it than that, something along the lines of '. matches any printable character', but I may be wrong) which is followed by a character that isn't a double quote. (Just finished reading all about the internals of Perl's RegEx engine in _Computer Science And Perl Programming_, bit of a heavy read, but I now know all sorts of useless things about it :) -- Lindsay Evans. Developer, Red Square Productions. [p] 8596.4000 [f] 8596.4001 [w] www.redsquare.com.au -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Taco Fleur Sent: Thursday, June 26, 2003 6:02 PM To: CFAussie Mailing List Subject: [cfaussie] RE: RegEx in DreamWeaver Perfect, Thanks that was it... I thought it would halt at the first double quote as I have [^] ??? snip/ --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MX Downunder AsiaPac DevCon - http://mxdu.com/
[cfaussie] RE: RegEx in DreamWeaver
One more for the regex guru's How about excluding the link when there is no content between the double quotes? Would adding {.,0} do the trick? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Lindsay Evans Sent: Thursday, 26 June 2003 6:01 PM To: CFAussie Mailing List Subject: [cfaussie] RE: RegEx in DreamWeaver The RegEx will match the first one, as it is matching any character (except for line breaks, I believe) any number of times. This would probably be a better way to go: a href=([^]*) Which matches any character that *isn't* a double quote any number of times. HTH -- Lindsay Evans. Developer, Red Square Productions. [p] 8596.4000 [f] 8596.4001 [w] www.redsquare.com.au -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Taco Fleur Sent: Thursday, June 26, 2003 5:41 PM To: CFAussie Mailing List Subject: [cfaussie] RegEx in DreamWeaver I am using a regex to find a string in DreamWeaver and I thought a href=(.*)[^] Would return: a href=index.cfm/page.application but instead it returns: a href=index.cfm/page.application class=moreMore../anbsp;span class=raqueraquo;/span/p/td Is my regex wrong or any other ideas? --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MX Downunder AsiaPac DevCon - http://mxdu.com/ --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MX Downunder AsiaPac DevCon - http://mxdu.com/ --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MX Downunder AsiaPac DevCon - http://mxdu.com/
[cfaussie] RE: RegEx in DreamWeaver
a href=([^]*) Try a href=([^]+) * means 0 or more + means 1 or more ? Means 0 or 1 One of the key things to understand about regexs is that they are greedy. That means that they get processed from left to right, and each criteria will claim as much as it can. The net result is that saying .* will match everything, and any criteria that follow it will never get a chance to operate. Often times this is not how you want things to work, you would prefer the opposite to happen. Perl ( and hence cfmx ) has support for a not greedy operator, you just stick ? After the + or * Eg: your orignial regex a href=.*?should now work but you might wanta href=.+? to skip the empty urls Jon. --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MX Downunder AsiaPac DevCon - http://mxdu.com/
[cfaussie] Re: regex against word
One I found was the apostrophe above the 'e' in décor. XML throws a wobbly at these types of characters and thought there may be a regex that could grab them when used in these rare occasions. Cheers Drew -Original Message- From: Taco Fleur [mailto:[EMAIL PROTECTED] Sent: Thursday, 5 June 2003 8:19 PM To: CFAussie Mailing List Subject: [cfaussie] Re: regex against word What kind of characters are they? Example would help. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Drew Sent: Thursday, 5 June 2003 5:03 PM To: CFAussie Mailing List Subject: [cfaussie] Re: regex against word microsoft word of course :) Cheers again Drew --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MX Downunder AsiaPac DevCon - http://mxdu.com/ --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MX Downunder AsiaPac DevCon - http://mxdu.com/ --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MX Downunder AsiaPac DevCon - http://mxdu.com/
[cfaussie] Re: regex against word
You don't really need to use a RegEx on this, you can just use the replace function on this, unless you want to remove any special character that makes XML fall over. replace(yourString, é, e, all) I guess your best bet would be to replace the character with the following ISO code or some other equivalent that won't make xml fall over replace(yourString, é, eacute;, all) I'm sure there is a tag or function somewhere that will do exactly what you want when you do a search in google or have a look at http://www.cflib.org/library.cfm?ID=1 Taco -Original Message- From: Andrew Parker [mailto:[EMAIL PROTECTED] Sent: Friday, 6 June 2003 8:58 AM To: CFAussie Mailing List Subject: [cfaussie] Re: regex against word One I found was the apostrophe above the 'e' in décor. XML throws a wobbly at these types of characters and thought there may be a regex that could grab them when used in these rare occasions. Cheers Drew -Original Message- From: Taco Fleur [mailto:[EMAIL PROTECTED] Sent: Thursday, 5 June 2003 8:19 PM To: CFAussie Mailing List Subject: [cfaussie] Re: regex against word What kind of characters are they? Example would help. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Drew Sent: Thursday, 5 June 2003 5:03 PM To: CFAussie Mailing List Subject: [cfaussie] Re: regex against word microsoft word of course :) Cheers again Drew --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MX Downunder AsiaPac DevCon - http://mxdu.com/ --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MX Downunder AsiaPac DevCon - http://mxdu.com/ --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MX Downunder AsiaPac DevCon - http://mxdu.com/ This email, together with any attachments, is intended for the named recipient(s) only and may contain privileged and confidential information. If received in error, please inform the sender as quickly as possible and delete this email and any copies from your computer system network. If not an intended recipient of this email, you must not copy, distribute or rely upon it and any form of disclosure, modification, distribution and/or publication of this email is prohibited. Unless stated otherwise, this email represents only the views of the sender and not the views of the Queensland Government. --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MX Downunder AsiaPac DevCon - http://mxdu.com/
[cfaussie] Re: regex against word
I guess your best bet would be to replace the character with the following ISO code or some other equivalent that won't make xmlfall over However. NOTE: XML only supports a small set of the escaped characters (not the same set that HTML supports) - so you may find that, while they dont break XML, you may not get the behaviour you actually want (this may, of course, depend on how you are you processing your XML for output). Gary Menzel IT Operations Brisbane -+- ABN AMRO Morgans Limited Level 29, 123 Eagle Street BRISBANE QLD 4000 PH: 07 333 44 828 FX: 07 3834 0828 If this communication is not intended for you and you are not an authorised recipient of this email you are prohibited by law from dealing with or relying on the email or any file attachments. This prohibition includes reading, printing, copying, re-transmitting, disseminating, storing or in any other way dealing or acting in reliance on the information. If you have received this email in error, we request you contact ABN AMRO Morgans Limited immediately by returning the email to [EMAIL PROTECTED] and destroy the original. We will refund any reasonable costs associated with notifying ABN AMRO Morgans. This email is confidential and may contain privileged client information. ABN AMRO Morgans has taken reasonable steps to ensure the accuracy and integrity of all its communications, including electronic communications, but accepts no liability for materials transmitted. Materials may also be transmitted without the knowledge of ABN AMRO Morgans. ABN AMRO Morgans Limited its directors and employees do not accept liability for the results of any actions taken or not on the basis of the information in this report. ABN AMRO Morgans Limited and its associates hold or may hold securities in the companies/trusts mentioned herein. Any recommendation is made on the basis of our research of the investment and may not suit the specific requirements of clients. Assessments of suitability to an individual's portfolio can only be made after an examination of the particular client's investments, financial circumstances and requirements. --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MX Downunder AsiaPac DevCon - http://mxdu.com/
[cfaussie] Re: regex against word
What kind of characters are they? Example would help. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Drew Sent: Thursday, 5 June 2003 5:03 PM To: CFAussie Mailing List Subject: [cfaussie] Re: regex against word microsoft word of course :) Cheers again Drew --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MX Downunder AsiaPac DevCon - http://mxdu.com/ --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MX Downunder AsiaPac DevCon - http://mxdu.com/
[cfaussie] Re: regex against word
microsoft word of course :) Cheers again Drew --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MX Downunder AsiaPac DevCon - http://mxdu.com/
[cfaussie] RE: RegEx for email checking
Taco There is not point really All you can do is check that it has an @ symbol and a .something In the end, I could meet the criteria for the check, but then just enter in a bodgy address anyway Regards Steve Onnis Domain Concept Designs +61 422 337 685 +61 3 9431 4249 http://www.domainconceptdesigns.com http://www.domainconceptdesigns.com/ [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] http://www.cfcentral.com.au http://www.cfcentral.com.au/ [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] (If you think it can't be done, you haven't asked me!) - Steve Onnis -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Taco Fleur Sent: Tuesday, January 21, 2003 9:15 PM To: CFAussie Mailing List Subject: [cfaussie] RegEx for email checking Just wondering! Has anyone out there managed to create a watertight regEx for checking and validating email addresses? I found a few out there, but once you put them under the microscope you find that they all seem to be missing something here and there. And also, has anyone got any idea where I can find the specifications for an email address, i.e. a document that explains what the max. min. chars are, what it can and can't contain etc.? I had a look at www.w3c.org but no luck If not, is there anyone interested in creating one as a team effort? I have some regEx examples that I have broken down and noted the questions and missing code, but my regEx is a bit rusty lately and besides I want to make sure it's a 1000% watertight check. not letting anyone get away with mistakes but also not denying anyone with a valid address... TIA Taco Fleur --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MX Downunder AsiaPac DevCon - http://mxdu.com/ --- You are currently subscribed to cfaussie as: archive@mail-archive.com To unsubscribe send a blank email to [EMAIL PROTECTED] MX Downunder AsiaPac DevCon - http://mxdu.com/
[cfaussie] RE: RegEx for email checking
Hi Steve, Correct me if I am wrong, but there are a lot more things you can check for with regEx, for example; - If it has a @ sign and only one - If the first part of the email has more than X characters, and less than X characters - If the first part of the email contains only letters, numbers, underscore or hyphen etc. - If the second part of the email more than X characters, and less than X characters - If the second part of the email contains only letters, numbers, underscore or hyphen etc. - If the second part of the email contains at least one dot and no more than one Etc. Etc. there are many more things you can check for, since I have not found any concrete and accurate info of what an email can consist of I am a bit stuck.. Taco Fleur Original Message From: Steve Onnis [EMAIL PROTECTED] Apparently from: [EMAIL PROTECTED] To: CFAussie Mailing List [EMAIL PROTECTED] Subject: [cfaussie] RE: RegEx for email checking Date: Tue, 21 Jan 2003 22:09:33 +1100 Taco There is not point really All you can do is check that it has an @ symbol and a .something In the end, I could meet the criteria for the check, but then just enter in a bodgy address anyway Regards Steve Onnis Domain Concept Designs +61 422 337 685 +61 3 9431 4249 http://www.domainconceptdesigns.com http://www.domainconceptdesigns.com/ [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] http://www.cfcentral.com.au http://www.cfcentral.com.au/ [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] (If you think it can't be done, you haven't asked me!) - Steve Onnis -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Taco Fleur Sent: Tuesday, January 21, 2003 9:15 PM To: CFAussie Mailing List Subject: [cfaussie] RegEx for email checking Just wondering! Has anyone out there managed to create a watertight regEx for checking and validating email addresses? I found a few out there, but once you put them under the microscope you find that they all seem to be missing something here and there. And also, has anyone got any idea where I can find the specifications for an email address, i.e. a document that explains what the max. min. chars are, what it can and can't contain etc.? I had a look at www.w3c.org but no luck If not, is there anyone interested in creating one as a team effort? I have some regEx examples that I have broken down and noted the questions and missing code, but my regEx is a bit rusty lately and besides I want to make sure it's a 1000% watertight check. not letting anyone get away with mistakes but also not denying anyone with a valid address... TIA Taco Fleur --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MX Downunder AsiaPac DevCon - http://mxdu.com/ --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MX Downunder AsiaPac DevCon - http://mxdu.com/ --- You are currently subscribed to cfaussie as: archive@mail-archive.com To unsubscribe send a blank email to [EMAIL PROTECTED] MX Downunder AsiaPac DevCon - http://mxdu.com/
[cfaussie] RE: RegEx for email checking
Attached is a javascript that I use to check... If you can't see the attachment, then you can grab it at http://r3v3ng.net/scripts/email_check.js Implimentation test : http://r3v3ng.net/scripts/email_test.html -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Taco Fleur Sent: Tuesday, 21 January 2003 9:15 PM To: CFAussie Mailing List Subject: [cfaussie] RegEx for email checking Just wondering! Has anyone out there managed to create a watertight regEx for checking and validating email addresses? I found a few out there, but once you put them under the microscope you find that they all seem to be missing something here and there. And also, has anyone got any idea where I can find the specifications for an email address, i.e. a document that explains what the max. min. chars are, what it can and can't contain etc.? I had a look at www.w3c.org but no luck If not, is there anyone interested in creating one as a team effort? I have some regEx examples that I have broken down and noted the questions and missing code, but my regEx is a bit rusty lately and besides I want to make sure it's a 1000% watertight check. not letting anyone get away with mistakes but also not denying anyone with a valid address... TIA Taco Fleur --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MX Downunder AsiaPac DevCon - http://mxdu.com/ email_check.js Description: Binary data --- You are currently subscribed to cfaussie as: archive@mail-archive.com To unsubscribe send a blank email to [EMAIL PROTECTED] MX Downunder AsiaPac DevCon - http://mxdu.com/
[cfaussie] RE: RegEx for email checking
if you're looking for 'official' specs for internet stuff, go straight to the horrses mouth: http://www.faqs.org/rfcs For email addressing, try starting with rfc-822: http://www.faqs.org/rfcs/rfc822.html cheers. +--+ | Turn on your Revenue Stream... | | Bolt on a Virtual Cash Register to your e-commerce site now. | | VeriPay from Xilo Online: http://www.xilo.com/veripay| +--+ -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Taco Fleur Sent: Tuesday, 21 January 2003 9:15 PM To: CFAussie Mailing List Subject: [cfaussie] RegEx for email checking Just wondering! Has anyone out there managed to create a watertight regEx for checking and validating email addresses? I found a few out there, but once you put them under the microscope you find that they all seem to be missing something here and there. And also, has anyone got any idea where I can find the specifications for an email address, i.e. a document that explains what the max. min. chars are, what it can and can't contain etc.? I had a look at www.w3c.org but no luck If not, is there anyone interested in creating one as a team effort? I have some regEx examples that I have broken down and noted the questions and missing code, but my regEx is a bit rusty lately and besides I want to make sure it's a 1000% watertight check. not letting anyone get away with mistakes but also not denying anyone with a valid address... TIA Taco Fleur --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MX Downunder AsiaPac DevCon - http://mxdu.com/ --- You are currently subscribed to cfaussie as: archive@mail-archive.com To unsubscribe send a blank email to [EMAIL PROTECTED] MX Downunder AsiaPac DevCon - http://mxdu.com/
[cfaussie] RE: RegEx for email checking
Yeah but once you fullfill those requirements, whats to say that it is actually a valid email address? [EMAIL PROTECTED] this would pass any email validater, but one would safly say that the email address is a crap one thats what I mean All you can do is check that its formatted properly, but as for if is a valid email address and the account exists, well good luck. I have added into my validation scripts to do a post to the actual domain used in the address and then check the response that you get back, IE if you get a Connection Failure response, then there is no way the address is valid, but then I cam across mail servers not using standard ports ect. Regards Steve Onnis Domain Concept Designs +61 422 337 685 +61 3 9431 4249 http://www.domainconceptdesigns.com http://www.domainconceptdesigns.com/ [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] http://www.cfcentral.com.au http://www.cfcentral.com.au/ [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] (If you think it can't be done, you haven't asked me!) - Steve Onnis -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of [EMAIL PROTECTED] Sent: Tuesday, January 21, 2003 10:17 PM To: CFAussie Mailing List Subject: [cfaussie] RE: RegEx for email checking Hi Steve, Correct me if I am wrong, but there are a lot more things you can check for with regEx, for example; - If it has a @ sign and only one - If the first part of the email has more than X characters, and less than X characters - If the first part of the email contains only letters, numbers, underscore or hyphen etc. - If the second part of the email more than X characters, and less than X characters - If the second part of the email contains only letters, numbers, underscore or hyphen etc. - If the second part of the email contains at least one dot and no more than one Etc. Etc. there are many more things you can check for, since I have not found any concrete and accurate info of what an email can consist of I am a bit stuck.. Taco Fleur Original Message From: Steve Onnis [EMAIL PROTECTED] Apparently from: [EMAIL PROTECTED] To: CFAussie Mailing List [EMAIL PROTECTED] Subject: [cfaussie] RE: RegEx for email checking Date: Tue, 21 Jan 2003 22:09:33 +1100 Taco There is not point really All you can do is check that it has an @ symbol and a .something In the end, I could meet the criteria for the check, but then just enter in a bodgy address anyway Regards Steve Onnis Domain Concept Designs +61 422 337 685 +61 3 9431 4249 http://www.domainconceptdesigns.com http://www.domainconceptdesigns.com/ [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] http://www.cfcentral.com.au http://www.cfcentral.com.au/ [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] (If you think it can't be done, you haven't asked me!) - Steve Onnis -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Taco Fleur Sent: Tuesday, January 21, 2003 9:15 PM To: CFAussie Mailing List Subject: [cfaussie] RegEx for email checking Just wondering! Has anyone out there managed to create a watertight regEx for checking and validating email addresses? I found a few out there, but once you put them under the microscope you find that they all seem to be missing something here and there. And also, has anyone got any idea where I can find the specifications for an email address, i.e. a document that explains what the max. min. chars are, what it can and can't contain etc.? I had a look at www.w3c.org but no luck If not, is there anyone interested in creating one as a team effort? I have some regEx examples that I have broken down and noted the questions and missing code, but my regEx is a bit rusty lately and besides I want to make sure it's a 1000% watertight check. not letting anyone get away with mistakes but also not denying anyone with a valid address... TIA Taco Fleur --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MX Downunder AsiaPac DevCon - http://mxdu.com/ --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MX Downunder AsiaPac DevCon - http://mxdu.com/ --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MX Downunder AsiaPac DevCon - http://mxdu.com/ --- You are currently subscribed to cfaussie as: archive@mail-archive.com To unsubscribe send a blank email to [EMAIL PROTECTED] MX Downunder AsiaPac DevCon - http://mxdu.com/
[cfaussie] RE: RegEx for email checking
In that case you are right, there really is nothing you can do that proofs the email is existing, only send an email and see if its real and doesn't bounce back. you could try FINGER user@host but thats not running everywhere, you could PING the host, but thats also disabled on most hosts now. You could check if the domains is really registered, but it's all going a bit to far. I was actually not refering to the above routine either, I was just interested in checking if it's correctly formatted, for security purposes (hacking) and just to disallow bogus people signing up quickly. Thanks for the JS script by the way Bryan Nolen... Taco Fleur Yeah but once you fullfill those requirements, whats to say that it is actually a valid email address? [EMAIL PROTECTED] this would pass any email validater, but one would safly say that the email address is a crap one thats what I mean All you can do is check that its formatted properly, but as for if is a valid email address and the account exists, well good luck. I have added into my validation scripts to do a post to the actual domain used in the address and then check the response that you get back, IE if you get a Connection Failure response, then there is no way the address is valid, but then I cam across mail servers not using standard ports ect. Regards Steve Onnis Domain Concept Designs +61 422 337 685 +61 3 9431 4249 http://www.domainconceptdesigns.com http://www.domainconceptdesigns.com/ [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] http://www.cfcentral.com.au http://www.cfcentral.com.au/ [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] (If you think it can't be done, you haven't asked me!) - Steve Onnis -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of [EMAIL PROTECTED] Sent: Tuesday, January 21, 2003 10:17 PM To: CFAussie Mailing List Subject: [cfaussie] RE: RegEx for email checking Hi Steve, Correct me if I am wrong, but there are a lot more things you can check for with regEx, for example; - If it has a @ sign and only one - If the first part of the email has more than X characters, and less than X characters - If the first part of the email contains only letters, numbers, underscore or hyphen etc. - If the second part of the email more than X characters, and less than X characters - If the second part of the email contains only letters, numbers, underscore or hyphen etc. - If the second part of the email contains at least one dot and no more than one Etc. Etc. there are many more things you can check for, since I have not found any concrete and accurate info of what an email can consist of I am a bit stuck.. Taco Fleur Original Message From: Steve Onnis [EMAIL PROTECTED] Apparently from: [EMAIL PROTECTED] To: CFAussie Mailing List [EMAIL PROTECTED] Subject: [cfaussie] RE: RegEx for email checking Date: Tue, 21 Jan 2003 22:09:33 +1100 Taco There is not point really All you can do is check that it has an @ symbol and a .something In the end, I could meet the criteria for the check, but then just enter in a bodgy address anyway Regards Steve Onnis Domain Concept Designs +61 422 337 685 +61 3 9431 4249 http://www.domainconceptdesigns.com http://www.domainconceptdesigns.com/ [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] http://www.cfcentral.com.au http://www.cfcentral.com.au/ [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] (If you think it can't be done, you haven't asked me!) - Steve Onnis -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Taco Fleur Sent: Tuesday, January 21, 2003 9:15 PM To: CFAussie Mailing List Subject: [cfaussie] RegEx for email checking Just wondering! Has anyone out there managed to create a watertight regEx for checking and validating email addresses? I found a few out there, but once you put them under the microscope you find that they all seem to be missing something here and there. And also, has anyone got any idea where I can find the specifications for an email address, i.e. a document that explains what the max. min. chars are, what it can and can't contain etc.? I had a look at www.w3c.org but no luck If not, is there anyone interested in creating one as a team effort? I have some regEx examples that I have broken down and noted the questions and missing code, but my regEx is a bit rusty lately and besides I want to make sure it's a 1000% watertight check. not letting anyone get away with mistakes but also not denying anyone with a valid address... TIA Taco Fleur --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MX Downunder AsiaPac DevCon - http://mxdu.com/ --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send
[cfaussie] RE: RegEx for email checking
Maybe you can use some webservices to ask the email server to validate it for you. http://www.serviceobjects.com/products/dots_email.asp?bhcp=1 http://www.cdyne.com/web-services.aspx?flash=1 I never used them though. Laurent Fontaine Sr Web Developer American Power Conversion Level 13, 65 Berry Street North Sydney, NSW 2060 AUSTRALIA tel: +61 2 8923 9339 @: [EMAIL PROTECTED] [EMAIL PROTECTED] Sent by: To: CFAussie Mailing List [EMAIL PROTECTED] [EMAIL PROTECTED] cc: emon.com.au Subject: [cfaussie] RE: RegEx for email checking 22/01/2003 07:28 AM Please respond to CFAussie Mailing List In that case you are right, there really is nothing you can do that proofs the email is existing, only send an email and see if its real and doesn't bounce back. you could try FINGER user@host but thats not running everywhere, you could PING the host, but thats also disabled on most hosts now. You could check if the domains is really registered, but it's all going a bit to far. I was actually not refering to the above routine either, I was just interested in checking if it's correctly formatted, for security purposes (hacking) and just to disallow bogus people signing up quickly. Thanks for the JS script by the way Bryan Nolen... Taco Fleur Yeah but once you fullfill those requirements, whats to say that it is actually a valid email address? [EMAIL PROTECTED] this would pass any email validater, but one would safly say that the email address is a crap one thats what I mean All you can do is check that its formatted properly, but as for if is a valid email address and the account exists, well good luck. I have added into my validation scripts to do a post to the actual domain used in the address and then check the response that you get back, IE if you get a Connection Failure response, then there is no way the address is valid, but then I cam across mail servers not using standard ports ect. Regards Steve Onnis Domain Concept Designs +61 422 337 685 +61 3 9431 4249 http://www.domainconceptdesigns.com http://www.domainconceptdesigns.com/ [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] http://www.cfcentral.com.au http://www.cfcentral.com.au/ [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] (If you think it can't be done, you haven't asked me!) - Steve Onnis -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of [EMAIL PROTECTED] Sent: Tuesday, January 21, 2003 10:17 PM To: CFAussie Mailing List Subject: [cfaussie] RE: RegEx for email checking Hi Steve, Correct me if I am wrong, but there are a lot more things you can check for with regEx, for example; - If it has a @ sign and only one - If the first part of the email has more than X characters, and less than X characters - If the first part of the email contains only letters, numbers, underscore or hyphen etc. - If the second part of the email more than X characters, and less than X characters - If the second part of the email contains only letters, numbers, underscore or hyphen etc. - If the second part of the email contains at least one dot and no more than one
[cfaussie] RE: RegEx for email checking
Cheers for that. Maybe you can use some webservices to ask the email server to validate it for you. http://www.serviceobjects.com/products/dots_email.asp?bhcp=1 http://www.cdyne.com/web-services.aspx?flash=1 I never used them though. Laurent Fontaine Sr Web Developer American Power Conversion Level 13, 65 Berry Street North Sydney, NSW 2060 AUSTRALIA tel: +61 2 8923 9339 @: [EMAIL PROTECTED] [EMAIL PROTECTED] Sent by: To: CFAussie Mailing List [EMAIL PROTECTED] [EMAIL PROTECTED] cc: emon.com.au Subject: [cfaussie] RE: RegEx for email checking 22/01/2003 07:28 AM Please respond to CFAussie Mailing List In that case you are right, there really is nothing you can do that proofs the email is existing, only send an email and see if its real and doesn't bounce back. you could try FINGER user@host but thats not running everywhere, you could PING the host, but thats also disabled on most hosts now. You could check if the domains is really registered, but it's all going a bit to far. I was actually not refering to the above routine either, I was just interested in checking if it's correctly formatted, for security purposes (hacking) and just to disallow bogus people signing up quickly. Thanks for the JS script by the way Bryan Nolen... Taco Fleur Yeah but once you fullfill those requirements, whats to say that it is actually a valid email address? [EMAIL PROTECTED] this would pass any email validater, but one would safly say that the email address is a crap one thats what I mean All you can do is check that its formatted properly, but as for if is a valid email address and the account exists, well good luck. I have added into my validation scripts to do a post to the actual domain used in the address and then check the response that you get back, IE if you get a Connection Failure response, then there is no way the address is valid, but then I cam across mail servers not using standard ports ect. Regards Steve Onnis Domain Concept Designs +61 422 337 685 +61 3 9431 4249 http://www.domainconceptdesigns.com http://www.domainconceptdesigns.com/ [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] http://www.cfcentral.com.au http://www.cfcentral.com.au/ [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] (If you think it can't be done, you haven't asked me!) - Steve Onnis -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of [EMAIL PROTECTED] Sent: Tuesday, January 21, 2003 10:17 PM To: CFAussie Mailing List Subject: [cfaussie] RE: RegEx for email checking Hi Steve, Correct me if I am wrong, but there are a lot more things you can check for with regEx, for example; - If it has a @ sign and only one - If the first part of the email has more than X characters, and less than X characters - If the first part of the email contains only letters, numbers, underscore or hyphen etc. - If the second part of the email more than X characters, and less than X characters - If the second part of the email
[cfaussie] RE: RegEx for email checking
I just wanted to comment on my own message, regarding the checking of email for existence.. I just remembered that it is possible to perform a session via telnet to the mailserver checking if it will accept any messages to the email in question. --- You are currently subscribed to cfaussie as: archive@mail-archive.com To unsubscribe send a blank email to [EMAIL PROTECTED] MX Downunder AsiaPac DevCon - http://mxdu.com/
[cfaussie] RE: RegEx for email checking
This email is to be read subject to the disclaimer below. Yes, and you can use nslookup or similar to find the MX record for the domain (which is a special type of DNS record listing the mail servers for a domain). Then you could telnet to each listed mail server. But I think that if something goes wrong and you get complaints from your users, you would have a rather tough time figuring out where your verification procedure went wrong. The method of emailing people a random password or token and requiring them to enter it is IMHO a much safer way of verifying not only the validity of an email address, but that the person signing up actually has access to it. Also the 'resolve host and then telnet' approach feels a bit like shooting mozzies with anti-aircraft artillery... Viktor Radnai Web Developer, National E-Commerce, Ernst Young Direct: +61 2 9248 4361 Taco Fleur [EMAIL PROTECTED] To: CFAussie Mailing List [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED]Subject: [cfaussie] RE: RegEx for email checking mon.com.au 22/01/2003 10:19 AM Please respond to CFAussie Mailing List I just wanted to comment on my own message, regarding the checking of email for existence.. I just remembered that it is possible to perform a session via telnet to the mailserver checking if it will accept any messages to the email in question. --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MX Downunder AsiaPac DevCon - http://mxdu.com/ NOTICE - This communication contains information which is confidential and the copyright of Ernst Young or a third party. If you are not the intended recipient of this communication please delete and destroy all copies and telephone Ernst Young on 1800 655 717 immediately. If you are the intended recipient of this communication you should not copy, disclose or distribute this communication without the authority of Ernst Young. Any views expressed in this Communication are those of the individual sender, except where the sender specifically states them to be the views of Ernst Young. Except as required at law, Ernst Young does not represent, warrant and/or guarantee that the integrity of this communication has been maintained nor that the communication is free of errors, virus, interception or interference. Liability limited by the Accountants Scheme, approved under the Professional Standards Act 1994 (NSW) --- You are currently subscribed to cfaussie as: archive@mail-archive.com To unsubscribe send a blank email to [EMAIL PROTECTED] MX Downunder AsiaPac DevCon - http://mxdu.com/
[cfaussie] RE: RegEx for email checking
Yes I beleive you are right, in most cases it will be the best solution to send an email with the password. Actually my initial discussion was not based on checking if the email exists or not, but it became a topic. I just wanted to correct myself. PS. If you would do it via telnet it would be better to do it the following way; telnet to host on port 25 HELO [domain name] MAIL FROM [email address] Which would return 220 www.safe-mail.net ESMTP Exim 3.22 #1 Tue, 21 Jan 2003 18:40:39 -0500 250 www.safe-mail.net Hello host [x.x.x.x] MAIL FROM: [EMAIL PROTECTED] 250 [EMAIL PROTECTED] is syntactically correct Yes, and you can use nslookup or similar to find the MX record for the domain (which is a special type of DNS record listing the mail servers for a domain). Then you could telnet to each listed mail server. But I think that if something goes wrong and you get complaints from your users, you would have a rather tough time figuring out where your verification procedure went wrong. The method of emailing people a random password or token and requiring them to enter it is IMHO a much safer way of verifying not only the validity of an email address, but that the person signing up actually has access to it. Also the 'resolve host and then telnet' approach feels a bit like shooting mozzies with anti-aircraft artillery... Viktor Radnai Web Developer, National E-Commerce, Ernst Young Direct: +61 2 9248 4361 Taco Fleur [EMAIL PROTECTED] To: CFAussie Mailing List [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED]Subject: [cfaussie] RE: RegEx for email checking mon.com.au 22/01/2003 10:19 AM Please respond to CFAussie Mailing List I just wanted to comment on my own message, regarding the checking of email for existence.. I just remembered that it is possible to perform a session via telnet to the mailserver checking if it will accept any messages to the email in question. --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MX Downunder AsiaPac DevCon - http://mxdu.com/ NOTICE - This communication contains information which is confidential and the copyright of Ernst Young or a third party. If you are not the intended recipient of this communication please delete and destroy all copies and telephone Ernst Young on 1800 655 717 immediately. If you are the intended recipient of this communication you should not copy, disclose or distribute this communication without the authority of Ernst Young. Any views expressed in this Communication are those of the individual sender, except where the sender specifically states them to be the views of Ernst Young. Except as required at law, Ernst Young does not represent, warrant and/or guarantee that the integrity of this communication has been maintained nor that the communication is free of errors, virus, interception or interference. Liability limited by the Accountants Scheme, approved under the Professional Standards Act 1994 (NSW) --- You are currently subscribed to cfaussie as: archive@mail-archive.com To unsubscribe send a blank email to [EMAIL PROTECTED] MX Downunder AsiaPac DevCon - http://mxdu.com/
[cfaussie] Re: RegEx for email checking
[EMAIL PROTECTED] resolves by every test, even vrfy recpient checks appear return the standard results from a locked down mail server. Email: [EMAIL PROTECTED] User: b.gates Domain: microsoft.com MX 10 = mailb.microsoft.com [131.107.3.123] - 220 inet-imc-03.redmond.corp.microsoft.com Microsoft.com ESMTP Server Tue, 21 Jan 2003 18:10:05 -0800 - HELO localhost - 250 inet-imc-03.redmond.corp.microsoft.com Hello [127.0.0.1] - MAIL FROM:[EMAIL PROTECTED] - 250 2.1.0 [EMAIL PROTECTED] OK - VRFY b.gates - 252 2.1.5 Cannot VRFY user, but will take message for [EMAIL PROTECTED] - VRFY [EMAIL PROTECTED] - 252 2.1.5 Cannot VRFY user, but will take message for [EMAIL PROTECTED] - RCPT TO:[EMAIL PROTECTED] - 250 2.1.5 [EMAIL PROTECTED] - RSET - 250 2.0.0 Resetting - QUIT - 221 2.0.0 inet-imc-03.redmond.corp.microsoft.com Service closing transmission channel Any server side testing of an email adress is imho pointless. Email a password for general but b.gates@microsoft ain't my address. and IU'd probably be willing to put money on the fact that any address translating however approximately to bubba gates at a microsoft domain isn't checked except once every six months for new funny hate mail to foward around the office. I also have a couple of addresses that would violate most extremely retentive verification. I've got a couple of blahlah.blahblah.com email addresses. And one blahblah.blahblah.blahblah.com not to mention the .com.au style addresses. I've also got one that I use fairly regularly as an anti spam defence with 40 or 50 characters before the @ and very few of my mail addressess can be pinged, vrfy'd or otherwise existence checked. Spammers have to work to qualify my addresses ; I generally either email passwords to my users if I need to verify the address, or treat any adress recieved as suspect and probably invalid. [EMAIL PROTECTED] wrote in message news:22138@cfaussie... Yes I beleive you are right, in most cases it will be the best solution to send an email with the password. Actually my initial discussion was not based on checking if the email exists or not, but it became a topic. I just wanted to correct myself. PS. If you would do it via telnet it would be better to do it the following way; telnet to host on port 25 HELO [domain name] MAIL FROM [email address] Which would return 220 www.safe-mail.net ESMTP Exim 3.22 #1 Tue, 21 Jan 2003 18:40:39 -0500 250 www.safe-mail.net Hello host [x.x.x.x] MAIL FROM: [EMAIL PROTECTED] 250 [EMAIL PROTECTED] is syntactically correct Yes, and you can use nslookup or similar to find the MX record for the domain (which is a special type of DNS record listing the mail servers for a domain). Then you could telnet to each listed mail server. But I think that if something goes wrong and you get complaints from your users, you would have a rather tough time figuring out where your verification procedure went wrong. The method of emailing people a random password or token and requiring them to enter it is IMHO a much safer way of verifying not only the validity of an email address, but that the person signing up actually has access to it. Also the 'resolve host and then telnet' approach feels a bit like shooting mozzies with anti-aircraft artillery... Viktor Radnai Web Developer, National E-Commerce, Ernst Young Direct: +61 2 9248 4361 Taco Fleur [EMAIL PROTECTED] To: CFAussie Mailing List [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED]Subject: [cfaussie] RE: RegEx for email checking mon.com.au 22/01/2003 10:19 AM Please respond to CFAussie Mailing List I just wanted to comment on my own message, regarding the checking of email for existence.. I just remembered that it is possible to perform a session via telnet to the mailserver checking if it will accept any messages to the email in question. --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MX Downunder AsiaPac DevCon - http://mxdu.com/ NOTICE - This communication contains information which is confidential and the copyright of Ernst Young or a third party. If you are not the intended recipient of this communication please delete and destroy all copies and telephone Ernst Young on 1800 655 717 immediately. If you are the intended recipient of this communication you should not copy, disclose or distribute this communication without the authority of Ernst Young. Any views expressed in this Communication are those of the individual sender, except where the sender specifically states them to be the views of Ernst Young. Except as required at law, Ernst Young