Extracting data from VOTable format by using XPath query

Script

import org.dom4j.*;
import org.dom4j.io.SAXReader;
import org.dom4j.xpath.*;

SAXReader reader = new SAXReader(false);
reader.setIncludeInternalDTDDeclarations(false);
reader.setIncludeExternalDTDDeclarations(false);


XPath xpathObj = new DefaultXPath(xpath);
HashMap map = new HashMap();
map.put(abbrevation,namespace);
xpathObj.setNamespaceURIs(map);


Document document = reader.read(new StringReader(xmltext));
List nodelist = xpathObj.selectNodes(document);

// Process the elements in the nodelist
ArrayList outputList = new ArrayList();
ArrayList outputXmlList = new ArrayList();
String val = null;
String xmlVal = null;
for (Iterator iter = nodelist.iterator(); iter.hasNext();) {
	Node element = (Node) iter.next();
	xmlVal = element.asXML();
	val = element.getStringValue();
	if (val != null && !val.equals("")) {
		outputList.add(val);
		outputXmlList.add(xmlVal);
	}

}

List nodelist=outputList;
List nodelistAsXML=outputXmlList;

Value

Value

Script

xPath="//h:VOTABLE[1]/h:RESOURCE/h:TABLE/h:DATA/h:TABLEDATA/h:TR/h:TD[position() = count(//h:VOTABLE/h:RESOURCE/h:TABLE/h:FIELD[@name = \""+columnName+"\"]/preceding-sibling::*)+1]"