How can I start a new "record" and then nest tags in that record?
but I'm getting output like:
<xml> <record> if (matches($line, "[0-9]")) then <data>people</data> else <name>people</name> </record> <record> if (matches($line, "[0-9]")) then <data>joe</data> else <name>joe</name> </record> ..
wheras I just want output like:
<record> <name>joe</name> <data>123</data> </record>
the query:
xquery version "3.0";
<xml> { for $line in db:open("foo.txt")//text() return <record> if (matches($line, "[0-9]")) then <data>{$line}</data> else <name>{$line}</name> </record> } </xml>
I think it's a matter of using the () and {} correctly. Pardon, yes, I'm literally reading a book on this, still trying to understand the syntax.
thanks,
Thufir