Question Re: xpath substring expression in Technology Q&A

xpath substring expression

Former Member — Wed, 16 Aug 2006 15:47:31 GMT

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"

Re: xpath substring expression

Former Member — Wed, 16 Aug 2006 16:31:53 GMT

Normal usage for XPath function is

substring-before(<xpath>,arg1,arg2)

So usage would be something like

substring-before("/p1:BookingOrders/Order/BookingCode","Y")

But question wherein context are you calling this fucntion?

Assuming its an XSL mapping.. then u wud call this within <xsl:value-of select="...> stmt.

Re: xpath substring expression

stefan_grube — Wed, 16 Aug 2006 17:36:31 GMT

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

Re: xpath substring expression

Shabarish_Nair — Wed, 16 Aug 2006 17:40:41 GMT

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

Chk tht blog. It sud give you an idea of how to build ur xpath query.

Re: xpath substring expression

Former Member — Wed, 16 Aug 2006 19:09:46 GMT

Hi,

You have missed on one closing bracket. Try this:

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

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

Regards

vijaya

Re: xpath substring expression

Former Member — Thu, 17 Aug 2006 08:00:07 GMT

Hi Luis,

it is

substring(//Order/BookingCode,1,2)

Regards,

Udo