Hey Guys,
Quick n00b question...
i have the following XML:
<row>
<UDPName>10014535-Test</UDPName>
<SpeedDialIndex>2</SpeedDialIndex>
<Label>mobile</Label>
<SpeedDialNumber>907********</SpeedDialNumber>
</row>
−
<row>
<UDPName>10014535-Test</UDPName>
<SpeedDialIndex>1</SpeedDialIndex>
<Label>talking clock</Label>
<SpeedDialNumber>9123</SpeedDialNumber>
</row>
-
<row>
<UDPName>10014573-Test</UDPName>
<SpeedDialIndex>1</SpeedDialIndex>
<Label>Work</Label>
<SpeedDialNumber>90203********</SpeedDialNumber>
</row>
(this is a cut down version of the XML.. there would be several hundred rows in the actual xml)
what i need to do is combine these xml bits into a comma seperated string like this:
10014535-Test,1,talking clock,9123,2,mobile,907********
10014573-Test,1,Work,90203*******
i.e. strip out all the tags, and combine any 2 elements with the same <UDPName> value... so that they're on one line with the UDPName showing once at the beginning.
whats the best way to approach this?
Dan