Hi Kendall,

Yes, your solution works too (see query below). Really appreciate your help!

Best,

Ron

declare namespace e = "http://example.com";

declare function e:strip-namespaces($node as node()) as node() {

typeswitch ($node)

case $node as document-node() return document { $node/node()/e:strip-namespaces(.) }

case $node as element() return element {local-name($node)} { $node/@*, $node/node()/e:strip-namespaces(.) }

default return $node

};

for $drug in e:strip-namespaces(db:open('DrugBankFail'))/drugbank/drug

where not(empty($drug/atc-codes/atc-code))

return <drug> {

<ATC5> { string-join(distinct-values($drug/name), ' | ') } </ATC5>,

<ATC4> { string-join(distinct-values($drug/atc-codes/atc-code/level[string-length(@code) = 5]), ' | ') } </ATC4>,

<ATC3> { string-join(distinct-values($drug/atc-codes/atc-code/level[string-length(@code) = 4]), ' | ') } </ATC3>,

<ATC2> { string-join(distinct-values($drug/atc-codes/atc-code/level[string-length(@code) = 3]), ' | ') } </ATC2>,

<ATC1> { string-join(distinct-values($drug/atc-codes/atc-code/level[string-length(@code) = 1]), ' | ') } </ATC1>

} </drug>

On September 1, 2017 at 5:21:11 PM, Kendall Shaw (kendall.shaw@workday.com) wrote:

I think my mail client altered my post to move ‘.’ characters to the end of what it thinks is a sentence.

This:

e:strip-namespaces().

Is supposed to be this:

e:strip-namespaces(.)