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