Changes

All functions in this module are assigned to the {{Code|<code><nowiki>http://basex.org/modules/csv}} </nowiki></code> namespace, which is statically bound to the {{Code|csv}} prefix.<br/>All errors are assigned to the {{Code|<code><nowiki>http://basex.org/errors}} </nowiki></code> namespace, which is statically bound to the {{Code|bxerr}} prefix.

=Rules=Conversion== ===XML: Direct, Attributes===

# * The resulting XML document has a {{Code|<csv>}} root element.# * Rows are represented via {{Code|<record>}} elements.# * Fields are represented via {{Code|<entry>}} elements. The value of a field is represented as text node.# * If the {{Code|header}} option is set to {{Code|true}}, the first text line is parsed as table header, and the {{Code|<entry>}} elements are replaced with the field names:## ** Empty names are represented by a single underscore ({{Code|_}}), and characters that are not valid in element names are replaced with underscoresor (when invalid as first character of an element name) prefixed with an underscore.## ** If the {{Code|lax}} option is set to {{Code|false}}, invalid characters will be rewritten to an underscore and the character’s four-digit Unicode, and underscores will be represented as two underscores ({{Code|__}}). The resulting element names may be less readable, but can always be converted back to the original field names.# * If {{Code|format}} is set to {{Code|attributes}}, field names will be stored in name attributes.

In ===Map=== If {{Code|format}} is set to {{Code|map}}, the CSV data will be converted to an XQuery map: * All records are enumerated with positive integers.* By default, all entries of a records are represented in a sequence.* If the {{Code|header}} option is set to {{Code|true}}, a map is created, which contains all field names and its values. '''A little advice''': in the Database Creation dialog of the GUI, when the if you select CSV parser is selected, Parsing and switch to the ''Parsing'' tab demonstrates , you can see the conversion effects of CSV to XML and the effects some of the single conversion options.

The {{Mark|Updated with Version 8.6}}: improved Excel compatibility In the following table, all available options are available:listed. The Excel column indicates what are the preferred options for data that is to be imported, or has been exported from Excel.

| Defines the character which separates the entries values of a single record in a single line.

* With {{Code|map}} conversion, the input is converted to an XQuery map| {{Code|direct}}, {{Code|attributes}}, {{Code|map}}

|{{Func|csv:parse|$input as xs:string|document-node(element(csv))}}<br/>{{Func|csv:parse|$input as xs:string, $options as map(xs:string, item())|document-nodeitem(element(csv))}}

|Converts the CSV data specified by {{Code|$input}} to an XML, and returns the result as {{Code|<csv/>}} valuedocument or a map. The {{Code|$options}} argument can be used to control the way the input is converted.

|{{Func|csv:serialize|$input as node()|xs:string}}<br/>{{Func|csv:serialize|$input as node(), $options as map(xs:string, item())|xs:string}}

|Serializes the node specified by {{Code|$input}} as CSV data, and returns the result as {{Code|xs:string}}.<br />XML documents Items can also be serialized as CSV JSON if the [[Serialization|SerializationParameter]] parameter {{Code|method}} is set to {{Code|csv}}.<br/>With the The {{Code|$options}} argument, can be used to control the way the node input is serialized can be controlled.

return csv:parse($text, map { 'header': 'true' () })

let $text options := map { 'lax': false() }let $input := file:read-text('some-data.csv')let $output := $input => csv:parse($options) => csv:serialize($options )return $input eq $output</pre> '''Example 3:''' Converts CSV data to an XQuery map item and serializes its contents:= {  ''lax'Query: 'no' }'<pre class="brush:xquery">let $xml text := csv"Name;City" || out:nl() || "John;Newton" || out:parsenl($text, $options)|| "Jack;Oldtown"let $csv options := map { 'separator': ';', 'format' : 'map', 'header' : true()}return csv:serializeparse($xmltext, $options)return $text eq $csv</pre> '''Result:'''<pre class="brush:xquery">map { 1: map { "City": "Newton", "Name": "John" }, 2: map { "City": "Oldtown", "Name": "Jack" }}

* Updated: return type of [[#csv:parse|csv:parse]] changed from now returns a document node instead of an element, or an XQuery map if {{Code|element(<csv>)format}} is set to {{Code|document-node(element(<csv>))map}}.