Why don;t you just go through the text as a list with CR as the
delimiter? This way you can have much more focused regular
expressions.

Just a thought,

Ian

----- Original Message -----
From: Michael Dinowitz <[EMAIL PROTECTED]>
Date: Mon, 30 Aug 2004 16:49:48 -0400
Subject: RE: regexp help
To: CF-Talk <[EMAIL PROTECTED]>

Really fast (Using the multi-line move of CFMX)

^([^#chr(13)#]+)[[:space:]]+([0-9]+)[[:space:]]+([0-9]+)[[:space:]]+([0-9]{2
}/[0-9]{2}/[0-9]{4})[[:space:]]+(USD)?[[:space:]]*([0-9.]+)$


   _____  

From: chris porter [mailto:[EMAIL PROTECTED]
Sent: Monday, August 30, 2004 4:41 PM
To: CF-Talk
Subject: Re: regexp help

and one last time....

DATA:

Product Name
Product Number            Qty      Est. Ship Date                 Your Ext.
Price
[dashed go here all the way across PITA email parser]

description of some item1
0344437                     1           03/12/2004                 USD
335.75

another description of some item1
0344734                     1           03/12/2004                 USD
335.75

and one last description of some item
0433447                     1           03/12/2004                 USD
335.75

part i need parsed by a regex

"description of some item1
0344437                     1           03/12/2004                 USD
335.75"

current REGEX:
([0-9]+)[ ]+([0-9]+)[ ]+([^ ]+)[ ]+([A-Z]{3})[ ]+([0-9.]+)

that regex matches everything on the 2nd line correctly, but nothing i add
to the beginning will match the first line. any thoughts?

Thanks!
-Chris
   _____________________________________
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]

Reply via email to