I get an email similar to the following: Name: Joe Bloggs City: New York Product: ICC Amount $97
I would like to build a text file which appends each new order as they come in. The format of the order should be as follows: Joe Bloggs, New York, ICC, $97, Sue Bloggs, Washington, AW, $127 Then, I can import this into my Access database for analysis. Currently, I have the following regexp: %SETPATTREGEXP="(?is)(^Name:.*?\nCity.*?\nProduct.*?\nAmount:?.*?\n).*"%- %REGEXPBlindMATCH="%TEXT" %Subpatt="1" But this will only do the following: Name: Joe Bloggs City: New York Product: ICC Amount $97 Name: Sue Bloggs City: Washington Product: AW Amount $127 This is not the format that I seek. Can anyone help? I really think there needs to be a better tutorial for understanding this regexp. Or even wizards that help you generate commonly sought expressions. -- Best regards, Jon mailto:[EMAIL PROTECTED] ______________________________________________________ Archives : http://tbtech.thebat.dutaint.com Moderators : mailto:[EMAIL PROTECTED] Unsubscribe: mailto:[EMAIL PROTECTED]
