I was hoping someone could help with the query needed to pull this information.
I really only need the first link and the li content from each li. preferable in separate fields but the same row.
The li on the page I need does not have a class or id.
ex. Ada | http://www.adaohio.org/
I have tried this "//li" but I get everything except the links and "//li/a/@href" gives me only the links
<a href="http://www.adaohio.org/">Ada</a> -
<a href="http://www.adafirst.com/">Chamber of Commerce</a> -
<a href="http://adalibrary.org/">Public Library</a>