E
Eric
I try to search pattern using RegExp method but it wont work. Data
contain emails which i save it into a textfile and want to read the
contents of email (Date, Customer Name, Street, Subject etc etc). Date,
Customer Name etc they all are in large braket and on the next line
their description is available. Needs help how to i read the word Date,
Customer Name etc and then fetch the next line record.
strPatternString = "\s\S"
sPattern = "Street\:\s*([" & strPatternString & "]+?)[\r\n]+"
----SAMPLE DATA----
[Date]
Sat Aug 05 14:06:12 EDT 2006
[Novell ID]
NSMITH4
[Subject]
PPV / VOD Research - Dispute - 1st Time - 711579
[Customer's Name]
EDWARD CAMPBELL
[Street]
5 WHEELER AVE APT 2
[City, State, Zip]
BRIDGEPORT CT, 06606
[Account Number]
006-0416-08
[Install Date]
06/21/2001
[Last Known Event Date]
06/29/2006
[PPV Hold]
No
[Monthly Rate]
186.52
[Current Services]
Optimum Voice
OOL FamilyorAbv
OR$20Discount
iO Silver Pkg
iO Box
PPOF
Addset: C/Rdy
OV World Call
OV Ported Number
[Type of Request]
Dispute - 1st Time
[Language]
English
[CRC PIN Instructions]
Yes
[Event Numbers/Date Range]
#77922 6/29, #78306 6/29, #77716 6/28, #77312 6/28
[Summary]
cust states that they and no one in the household ever
ordered those ppv movies.cust requesting credit of
$35.80.
[Box Verification by Customer]
2,SABKDTHBF,Yes,Yes,Yes,Yes
[MD Page ID]
1
[Control Number]
651789
contain emails which i save it into a textfile and want to read the
contents of email (Date, Customer Name, Street, Subject etc etc). Date,
Customer Name etc they all are in large braket and on the next line
their description is available. Needs help how to i read the word Date,
Customer Name etc and then fetch the next line record.
strPatternString = "\s\S"
sPattern = "Street\:\s*([" & strPatternString & "]+?)[\r\n]+"
----SAMPLE DATA----
[Date]
Sat Aug 05 14:06:12 EDT 2006
[Novell ID]
NSMITH4
[Subject]
PPV / VOD Research - Dispute - 1st Time - 711579
[Customer's Name]
EDWARD CAMPBELL
[Street]
5 WHEELER AVE APT 2
[City, State, Zip]
BRIDGEPORT CT, 06606
[Account Number]
006-0416-08
[Install Date]
06/21/2001
[Last Known Event Date]
06/29/2006
[PPV Hold]
No
[Monthly Rate]
186.52
[Current Services]
Optimum Voice
OOL FamilyorAbv
OR$20Discount
iO Silver Pkg
iO Box
PPOF
Addset: C/Rdy
OV World Call
OV Ported Number
[Type of Request]
Dispute - 1st Time
[Language]
English
[CRC PIN Instructions]
Yes
[Event Numbers/Date Range]
#77922 6/29, #78306 6/29, #77716 6/28, #77312 6/28
[Summary]
cust states that they and no one in the household ever
ordered those ppv movies.cust requesting credit of
$35.80.
[Box Verification by Customer]
2,SABKDTHBF,Yes,Yes,Yes,Yes
[MD Page ID]
1
[Control Number]
651789