On 2020-02-19 6:10 a.m., Martin Honnen wrote:
Am 19.02.2020 um 15:08 schrieb thufir:
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>
Nest any contained expression in further curly braces
{
if (matches($line, "[0-9]")) then <data>{$line}</data> else <name>{$line}</name>
}
</record> } </xml>
that was quite helpful, thanks. I'm getting:
<name>joe</name> </record> <record> <data>phone1</data> </record> <record> <data>phone2</data> </record>
and want to only open the new record tab for something like:
<record> <name>joe</name> <data>phone1</data> <data>phone2</data> </record>
but get "incomplete if statement" when I try to add open and close record tags inside each if statement.
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>
thanks,
Thufir