What's the quickest way/tool to sort a 1000 entries xml file?
Your requirements: The xml is parked on your desktop. You only need to sort it just once so you can manually examine it. Sort by the tag "relevance:score".
How would you go about it? Would you:
A) Craft a pipe stream of shell utils?
B) Use the heavy tools - a Java main() that with uses JDom?
C) Refresh the XSLT skills you never had?
D) Try your luck with a Python script?
E) search for an online XML editor tool?
F) Or, my pick at the bottom.
Example xml document to sort:
<feed> <entry> <title>Bibi</title> <score>0.21000001</score> </entry> <entry> <title>Lapid</title> <score>0.42000002</score> </entry> <entry> <title>Yechimovich</title> <score>0.235</score> </entry> <!--- 997 more entries --> </feed>
My Pick: considered all the above but it sounded like a headache for a simple sort operation. So I've .... thrown the file at MS Excel, turns out it can digest it rather well, and then I sorted by the score column. Yes! Surprising. But crappy MS Excel did the job (the original schema had more nesting than the document in the example above).
Life-saver lesson: Spend time picking the right tool for the job, than on the job itself.
One click to sort |
No comments:
Post a Comment