csv-to-xml-conversion-sample.xql

xquery version "3.1";

(: Copy your CSV file to /db/import collection then run in eXide
 : 
 : Sample csv file :
 : 
 : Afghanistan;AFG
 : Albania;ALB
 : ...
 : Zambia;ZMB
 : Zimbabwe;ZWE
 :)
 
let $data := tokenize(
  util:binary-to-string(util:binary-doc('/db/import/world-countries.csv')),
  codepoints-to-string((13))
)
return
  <Selector Name="ISOAlpha3WorldCountries">
    {
    for $l in $data
    let $tokens := tokenize($l, ';')
    return 
    <Option>
      <Value>{ $tokens[2] }</Value>
      <Name>{ normalize-space($tokens[1]) }</Name>
    </Option>
    }
</Selector>