Advertisement
weeez

xquery

Jun 8th, 2017
116
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.40 KB | None | 0 0
  1. for $it in $input
  2. return
  3. <Logic>
  4. {
  5. for $x in $it/Shipment
  6. return
  7. <Shipment>
  8. <ShipmentHeader>
  9. {
  10. let $head := $x/ShipmentHeader
  11. return data($head)
  12. }
  13. </ShipmentHeader>
  14. <Data>
  15. {
  16. let $date := $x/Date
  17. let $day := substring(data($date),1,2)
  18. let $month := substring(data($date),4,2)
  19. let $year := substring(data($date),7,4)
  20.  
  21. let $subString := concat($year, $month, $day)
  22. return $subString
  23. }
  24. </Data>
  25. <ShipmentNumber>
  26. {
  27. let $num := $x/ShipmentNumber
  28. return data($num)
  29. }
  30. </ShipmentNumber>
  31. </Shipment>
  32.  
  33. }
  34. <Shipper>
  35. {
  36. for $x in $it/Shipper
  37. return $x
  38. }
  39. </Shipper>
  40. </Logic>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement