xpath substring expression

[Former Member]

Hi,

I need to get a substring from a xml document via xpath expression which has data. Can someone help.

Here's the data and what I want to do is via xpath expression return "20" only (1 thru 2nd position) of the BookingCode node.

Not sure how to substring via xpath expression.

Thanks for your help

 <?xml version="1.0" encoding="UTF-8" ?> 
 <ns0:BookingOrders xmlns:ns0="urn:prueba:abap_mapping">
  <Order>
   <BookingCode>20Y34L</BookingCode> 
   <Passenger>
    <Name>Smith</Name> 
    <Address>123 Main St.</Address> 
   </Passenger>
   <Flight>
    <Date>04042004</Date> 
    <AirlineID>SX</AirlineID> 
    <FlightNumber>21</FlightNumber> 
    <From>ZRH</From> 
    <To>FRA</To> 
   </Flight>
  </Order>
 </ns0:BookingOrders>

This Xpath expression does not work

<b>/p1:BookingOrders/Order/BookingCode[(substring(.,2)]</b>

With the second operand = "20"

[stefan_grube]

Check this blog:

/people/shabarish.vijayakumar/blog/2006/06/07/customise-your-xpath-expressions-in-receiver-determination

You can do your request similar.

Regards

Stefan