Have you tried matching at the start of the string with caret [^]?

Have you tried to first just pulling out the text 'anything here' from within the colon [:] boundary markers, before looking for numeric strings?

have you considered doing your regex in the database (probably faster), which might employ a non-DFA regex engine?

Bill

William M. Conlon, P.E., Ph.D.
To the Point
2330 Bryant Street
Palo Alto, CA 94301
   vox:  650.327.2175 (direct)
   fax:  650.329.8335
mobile:  650.906.9929
e-mail:  mailto:[EMAIL PROTECTED]
   web:  http://www.tothept.com


On Feb 7, 2008, at 8:59 AM, Wolf, Gene wrote:

OK, I am pulling my hair out and I figure some of you have had quite a bit more experience with this than I have. Here's what I'm trying to get the regex expression in Witango to do:

I want to process all records with a memo field containing :anything here:

Now, I'm selecting records and processing an array applying the regex expression to the appropriate field. I'm using the following command:

   <@REGEX EXPR=":{1,}[.]+{1,}:{1,}" STR=.. (you get the idea)

This expression is accepting anything that has at least one : in it. I really want the field selected if it two : in it. So for example I do not want Title: but I do want :Title: I don't want :important

But I do want :important:

   What am I doing wrong in the above code?


Gene Wolf
Supervisor, Business Systems
DRS Sensors & Targeting Systems-Optronics
2330 Commerce Park Drive NE
Palm Bay, Florida 32905
Phone: 321-309-0685
           321-309-0202 (fax)

Dictionary.com Word of the Day
http://dictionary.reference.com/wordoftheday/

This e-mail, including any attached files, may contain confidential and privileged information for the sole use of the intended recipient. Any review, use, distribution, or disclosure by others is strictly prohibited. If you are not the intended recipient (or authorized to receive information for the intended recipient), please contact the sender by reply e-mail and delete all copies of this message.

"This (document/presentation) may contain technical data as defined in the International Traffic In Arms Regulations (ITAR) 22 CFR 120.10. Export of this material is restricted by the Arms Export Control Act (22 U.S.C. 2751 et seq.) and may not be exported to foreign persons without prior written approval from the U.S. Department of State."

______________________________________________________________________ __ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
________________________________________________________________________
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf

Reply via email to