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
--
Emmanuelle Morlock
IGE CNRS - soutien aux projets d'édition TEI - humanités numériques
UMR 5189 HISoMA
http://www.hisoma.mom.fr/
04 72 71 58 40
06 85 84 69 16
@emma_morlock