RegExp

[crmpicco]

I have this code below:

<%

theStr = xmldoc.documentelement.selectnodes("dataElementsMaster").item(0).selectnodes("dataElementsIndiv").item(k).selectnodes("miscellaneousRemarks").item(0).selectnodes("remarks").item(0).selectnodes("freetext").item(0).text



'... Split the <freetext> XML Reply by : and ,
Dim expression_5: Set expression_5 = New RegExp
expression_5.Pattern = "[^:]*:([^/]*)/?"
expression_5.Global = True
Dim match_5, first_matches_5
Set first_matches_5 = expression_5.Execute(theStr)

dim sMyArray_5
sMyArray_5 = Array("Adult Net Net","Weekend Supp.","Pre-Addon","Markup","Agent Markup","Gross Fare","Fuel Surcharge","Tax","TOTAL")
counter = 0
For Each match_5 In first_matches_5
response.write "<tr bordercolor=#ececec><td align=right colspan=30><font face=verdana size=2><b>"& sMyArray_5(counter) &"</b>&nbsp;</font></td>"
if counter = 10 then
response.write "<td></td>"
else
response.write "<td align=right><font face=verdana size=2>&nbsp;" & match_5.SubMatches(0) & "</font></td>"
response.write "<td width=175>&nbsp;&nbsp;</td></tr>"
end if
counter = counter+1
Next


theStr's output is:

ADTNN:870.00/WKEND:20.00/ADDON:0.00/MKUP:20.00/AGTMKUP:40.00/FARE:950.00/FUEL:0.00/TAX:134.20/TTL:1,084.20

I need to find a way to pick out the Agent Markup as i need to do some calculations on it. How can i do this?

TIA.

Picco

[glenngv]

Why do the "freetext" node contain such a long and mixed data?
If you put each data in a node, the retrieval would be faster and easier and no need for RegExp but pure DOM method.

<freetext>
<adtnn>870.00</adtnn>
<wkend>20.00</wkend>
...
<agtmkup>40.00</agtmkup>
...
</freetext>