another regular expressions question...how would i go about parsing out the values from the examples below...i need the same pattern to parse all of the below examples using match...
something like
re.Pattern = "((/\w+).*?)"
Set Matches2 = re.Execute(Match1.SubMatches(2))
k = 0
For Each Match2 In Matches2
Set Match2 = Matches2(k)
k = k + 1
MsgBox Match2.SubMatches(0)
Next
...the output i am looking for would be(1st example i will use):
/spp,2p9
/ta,61 mo 03-26-97
/cn,01
/zlsz,0005
/rte,74.50
/SPP 2P9 /TA 61 MO 03-26-97 /CN 01/ZLSZ 00005 /RTE 74.50
/TN 212 422-0824 /DES RJ21X /LPIC NYC/LPCX 0698 /LPCA SN 11-16-99 /PIC WTL /PICX 0555/PCA SN 08-21-00
/PCA CN 08-21-00
/CX 212 422-3278/HTG 104 /TBE B/CAT 3/CTX 0076 /LCC A3I /CN 01/FNM TTC /DPG 0076 /LPIC NYC/LPCX 0698 /LPCA DF 08-05-95 /PIC WTL /PICX 0555/PCA SN 08-21-00
thanks for any help in advance
keith
something like
re.Pattern = "((/\w+).*?)"
Set Matches2 = re.Execute(Match1.SubMatches(2))
k = 0
For Each Match2 In Matches2
Set Match2 = Matches2(k)
k = k + 1
MsgBox Match2.SubMatches(0)
Next
...the output i am looking for would be(1st example i will use):
/spp,2p9
/ta,61 mo 03-26-97
/cn,01
/zlsz,0005
/rte,74.50
/SPP 2P9 /TA 61 MO 03-26-97 /CN 01/ZLSZ 00005 /RTE 74.50
/TN 212 422-0824 /DES RJ21X /LPIC NYC/LPCX 0698 /LPCA SN 11-16-99 /PIC WTL /PICX 0555/PCA SN 08-21-00
/PCA CN 08-21-00
/CX 212 422-3278/HTG 104 /TBE B/CAT 3/CTX 0076 /LCC A3I /CN 01/FNM TTC /DPG 0076 /LPIC NYC/LPCX 0698 /LPCA DF 08-05-95 /PIC WTL /PICX 0555/PCA SN 08-21-00
thanks for any help in advance
keith
