<dashboard> <search id="mySearch1"> <query>|makeresults </query> </search> <search id="mySearch2"> <query>* </query> </search> Goal: Need to make a table like: id query mySearch1 |makeresults mySearch2 * I tried using the spath command such as: | spath input=eai:data output=ID path=dashboard.search{@id} | spath input=eai:data output=query path=dashboard.search.query But this only gives me the first id (same if I don't specify a path) Then if I use the rex command to pull the id, I have 2 ids and 2 queries with no way to match which goes with which. Regular expressions for XML isn't a great idea to pull the whole <search id="searchID"> ... </search> tag into a field but the spath command isn't giving me that option. Any ideas? ... View more