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.

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.

| Specifies if how quotes should be are parsed in :* Parsing: If the option is enabled, quotes at the input start and end of a value will be treated as control characters. Separators and generated newlines within the quotes will be adopted without change.* Serialization: If the option is enabled, the value will be wrapped with quotes. A quote character in the outputvalue will be encoded according to the rules of the {{Code|backslashes}} option.

| Specifies if how quotes and other characters are escaped by backslashes:* Parsing: If the option is enabled, {{Code|\r}}, {{Code|n}} and {{Code|\t}} will be replaced with the corresponding control characters. All other escaped characters will be adopted as literals (e.g.: {{Code|\"}} → {{Code|"}}). OtherwiseIf the option is disabled, two consecutive quotes will be replaced with a double single quote (unless {{Code|quotes}} is enabled and the quote is encoded by the first or last character of a second consecutive quote (value).* Serialization: If the option is enabled, {{Code|\r}}, {{Code|n}}, {{Code|\t}}, {{VersionCode|8.0"}})and the separator character will be encoded with a backslash. If the option is disabled, quotes will be duplicated.

|{{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())|item()}}

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

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

let $text options := map { 'lax': false() }let $input := file:read-text('some-data.csv')let $options output := { 'lax': 'no' }let $xml :input = > csv:parse($text, $options)let $csv := > csv:serialize($xml, $options)return $text input eq $csvoutput

let $options :=map { <csv'separator':options> <csv:separator value=';'/>, <csv 'format' :format value='map'/>, <csv: 'header value='yes'/> </csv:options>true()}let $map := return csv:parse($text, $options)return map:serialize($map)

<pre class="brush:xmlxquery">map { 1: map {

2: map {