Selecting Distinct Values using XPath Expression

Hi,

XPath is one of the flexible standard for querying an xml document.

Let us consider the following CD xml as example:-

Empire Burlesque Bob Dylan 10.90 Hide your heart Bonnie Tyler 9.90 Greatest Hits Dolly Parton 9.90 Hide your heart Bonnie Tyler 9.90

In the above xml, if we would like to get distinct country names, then we can make use of the preceding-sibling property to check for any
existence of the country name so as to filter and show only distinct country names.

/catalog/cd[not(@country=preceding-sibling::cd/@country)]/@country

The above expression would select only distinct country names i.e. UK and USA only once each.

Cheers.

New on Geeks with Blogs

Get the Size of a Directory in Linux the Easy Way

du -sh for the quick answer, ncdu for the cleanup, df for the disk itself: every command for checking directory size in Linux, plus why du and df never agree.

Vim Search and Replace: The Ultimate Guide

One :%s command replaces every match in a file before a find dialog would even open. The Vim substitute patterns worth the muscle memory: flags, ranges, capture groups, and multi-file edits.

Because of AI, You Need a New Development Team

Your existing team is buried in the complexity of your existing product. AI rewards the team with a blank slate. Most companies don't have one.

The Offshore Problem That Starts With a "Yes"

The stories about offshore "not working" are rarely about skill. They are about an invisible communication gap, and it starts the moment someone says yes.