Hi all,
I'm trying to do some xquery with the GUI in a standalone install. As I'm beginning with xquery, I rely a lot on the examples given in the doc. But I don't manage to be successful with http://docs.basex.org/wiki/CSV_Module for what I need.
I'd like to get a result formatted in csv (separator : ';' or whatever) so tha I can directly import in a spreadsheet the results exported file.
Here's the begining of my query :
for $lettre in db:open('myDB')//TEI where $lettre//opener//addrLine[not(contains(.,'Adresse ?'))] let $title := $lettre//teiHeader//title let $destinataire := $lettre//profileDesc/creation/persName[@type='destinataire'] let $expediteur := $lettre//profileDesc/creation/persName[@type='expediteur'] let $date := $lettre//profileDesc//date let $locName := $lettre//profileDesc/creation/location/placeName[@type='PlaceExp'] let $locGeo := $lettre//profileDesc/creation/location/geo
then I guess I should have something like : - a variable for the option... is let $options := {'separator':';'} correct ? something to put all the variable as a result let $fields := ... ? then return csv:serialize ($fields, $options)
??? thanks for helping even if this sounds too basic !
best
emmanuelle