Advertisement
Guest User

Untitled

a guest
Aug 22nd, 2017
67
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.21 KB | None | 0 0
  1. <ABT><pid>101</pid><date>10/12/13</date><name>AAA</name></ABT>
  2. <ABT><pid>102</pid><date>11/12/13</date><name>BBB</name></ABT>
  3. <ABT><pid>101</pid><date>09/12/13</date><name>AAA</name></ABT>
  4. <ABT><pid>102</pid><date>24/12/13</date><name>BBB</name></ABT>
  5. <JRE><pid>101</pid><date>01/12/13</date><name>AAA</name></JRE>
  6. <JRE><pid>102</pid><date>02/12/13</date><name>BBB</name></JRE>
  7.  
  8. <JRE><pid>101</pid><date>01/12/13</date><name>AAA</name></JRE>
  9. <ABT><pid>101</pid><date>09/12/13</date><name>AAA</name></ABT>
  10. <ABT><pid>101</pid><date>10/12/13</date><name>AAA</name></ABT>
  11. <JRE><pid>102</pid><date>02/12/13</date><name>BBB</name></JRE>
  12. <ABT><pid>102</pid><date>11/12/13</date><name>BBB</name></ABT>
  13. <ABT><pid>102</pid><date>24/12/13</date><name>BBB</name></ABT>
  14.  
  15. $ sed -e 's/<pid>/& /' -e 's/<date>/& /' file | sort -nk2 -k3 | sed 's/ //g'
  16. <JRE><pid>101</pid><date>01/12/13</date><name>AAA</name></JRE>
  17. <ABT><pid>101</pid><date>09/12/13</date><name>AAA</name></ABT>
  18. <ABT><pid>101</pid><date>10/12/13</date><name>AAA</name></ABT>
  19. <JRE><pid>102</pid><date>02/12/13</date><name>BBB</name></JRE>
  20. <ABT><pid>102</pid><date>11/12/13</date><name>BBB</name></ABT>
  21. <ABT><pid>102</pid><date>24/12/13</date><name>BBB</name></ABT>
  22.  
  23. xidel --xquery 'for $i in doc("file.xml")/* order by $i/pid, $i, $i/date return $i' --output-format xml
  24.  
  25. <root>
  26. <ABT>
  27. <pid>101</pid>
  28. <date>10/12/13</date>
  29. <name>AAA</name>
  30. </ABT>
  31. <ABT>
  32. <pid>102</pid>
  33. <date>11/12/13</date>
  34. <name>BBB</name>
  35. </ABT>
  36. <ABT>
  37. <pid>101</pid>
  38. <date>09/12/13</date>
  39. <name>AAA</name>
  40. </ABT>
  41. <ABT>
  42. <pid>102</pid>
  43. <date>24/12/13</date>
  44. <name>BBB</name>
  45. </ABT>
  46. <JRE>
  47. <pid>101</pid>
  48. <date>01/12/13</date>
  49. <name>AAA</name>
  50. </JRE>
  51. <JRE>
  52. <pid>102</pid>
  53. <date>02/12/13</date>
  54. <name>BBB</name>
  55. </JRE>
  56. </root>
  57.  
  58. xidel --xquery '<root>
  59. {for $i in doc("file.xml")/*/*
  60. order by $i/pid, $i, $i/date
  61. return $i}
  62. </root>' --output-format xml
  63.  
  64. xidel --xquery '<root>{for $i in doc("file.xml")/*/* order by $i/pid, $i, $i/date return $i}</root>' --output-format xml
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement