extract the DepartureTerminal from this XML

[crmpicco]

how do i extract the DepartureTerminal from this XML?

Cheers.

Picco

<code>
<PoweredAir_MultiAvailabilityReply>
- <DepartureRecommendedSegment>
- <RecommendedSegment>
- <FlightInfo>
<DepartureDate>19 July</DepartureDate>
<DepartureTime>17:15</DepartureTime>
<ArrivalDate>19 July</ArrivalDate>
<ArrivalTime>18:35</ArrivalTime>
<DepartureAirport>GLA</DepartureAirport>
<DepartureAirportName>Glasgow Int'l</DepartureAirportName>
<DepartureCityName>Glasgow</DepartureCityName>
<ArrivalAirport>LHR</ArrivalAirport>
<ArrivalAirportName>Heathrow</ArrivalAirportName>
<ArrivalCityName>London</ArrivalCityName>
<Airline>BD</Airline>
<AirlineName>BMI British Midland</AirlineName>
<FlightNumber>11</FlightNumber>
<Class>YOSBKMHQVGWEX</Class>
<ClassName>Economy</ClassName>
<AircraftType>320</AircraftType>
<AircraftName>Airbus A320-100/200 2 Jet engines</AircraftName>
<NoOfStops>0</NoOfStops>
<DepartureTerminal>M</DepartureTerminal>
<ArrivalTerminal>1</ArrivalTerminal>
<CodeSharing />
<CodeSharingName />
- <LevelOfAccess>
<Type>1A</Type>
<Type>LSA</Type>
<Type>M</Type>
</LevelOfAccess>
<DepartureAPIDate>190705</DepartureAPIDate>
<ArrivalAPIDate>190705</ArrivalAPIDate>
</FlightInfo>
</code>

 

[chiph]

It's not possible right now, because it's invalid XML -- you're missing the closing tags for:
[tab]RecommendedSegment
[tab]DepartureRecommendedSegment
[tab]PoweredAir_MultiAvailabilityReply

But once you correct that, I think an XPath that will work for you is:
[tab]code/FlightInfo/DepartureTerminal

Chip H.


____________________________________________________________________
Click here to learn Ways to help with Tsunami Relief
If you want to get the best response to a question, please read FAQ222-2244 first

 

[CubeE101]

or just...
"//DepartureTerminal"

If you are using DOM, it's...
DomDocument.SelectSingleNode("//DepartureTerminal")

If you are using XSL, it's...
<xsl:value-of select="//DepartureTerminal"/>

-Josh


PROGRAMMER: Red-eyed, mumbling mammal capable of conversing with inanimate objects.