Bureaucrats, editor, reviewer, Administrators
13,550
edits
Changes
Jump to navigation
Jump to search
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.
let $text := file:read-text('some-data.csv')
→Options
==Options==
{| class="wikitable sortable" width="100%"
! Allowed
! Default
! Excel
|- valign="top"
| {{Code|separator}}
| Defines the character which separates the entries values of a single record in a single line.
| {{Code|comma}}, {{Code|semicolon}}, {{Code|colon}}, {{Code|tab}}, {{Code|space}} or a ''single character''
| {{Code|comma}}
| {{Code|semicolon}}
|- valign="top"
| {{Code|header}}
| {{Code|yes}}, {{Code|no}}
| {{Code|no}}
|
|- valign="top"
| {{Code|format}}
| {{Code|direct}}, {{Code|attributes}}, {{Code|map}}
| {{Code|direct}}
|
|- valign="top"
| {{Code|lax}}
| {{Code|yes}}, {{Code|no}}
| {{Code|yes}}
| {{Code|no}}
|- valign="top"
| {{Code|quotes}}
| Specifies if how quotes are parsed:* Parsing: If the option is enabled, quotes at the beginning start and the end of a field should value will be treated as control characters. Separators and newlines within the quotes will be detectedadopted without change.* Serialization: If the option is enabled, and generated as such 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.
| {{Code|yes}}, {{Code|no}}
| {{Code|yes}}
| {{Code|yes}}
|- valign="top"
| {{Code|backslashes}}
| Specifies if how quotes and other characters are escaped by backslashes, or if quotes are encoded by a second consecutive quote:* During parsing, if Parsing: If the option is enabled, <code>{{Code|\r<code>}}, <code>\{{Code|n<code> }} and <code>{{Code|\t<code> }} will be replaced with the corresponding control characters. All other escaped characters will be adopted as literals (e.g.: <code>{{Code|\"<code> }} → <code>{{Code|"<code>}}). If the option is disabled, two consecutive quotes will be replaced with a single quote (see unless {{Code|quotes}} is enabled and the quote is the <code>first or last character of a value).* Serialization: If the option is enabled, {{Code|\r}}, {{Code|n}}, {{Code|\t}}, {{Code|"}} and the separator character will be encoded with a backslash. If the option is disabled, quotes</code> option for exceptions)will be duplicated.
| {{Code|yes}}, {{Code|no}}
| {{Code|no}}
| {{Code|no}}
|}
'''Query:'''
<pre class="brush:xquery">
let $options := map { 'lax': false() }
let $xml input := csvfile:parseread-text($text, $options'some-data.csv')let $output := $input => csv :parse($options) = > csv:serialize($xml, $options)return $text input eq $csvoutput
</pre>
<pre class="brush:xquery">
let $text := "Name;City" || out:nl() || "John;Newton" || out:nl() || "Jack;Oldtown"
let $options :=map { <csv:options> <csv'separator':separator value=';'/>, <csv 'format' :format value='map'/>, <csv: 'header value='yes'/> </csv:options>true()}
return csv:parse($text, $options)
</pre>
'''Result:'''
<pre class="brush:xmlxquery">map { 1: map {
"City": "Newton",
"Name": "John"
},
2: map {
"City": "Oldtown",
"Name": "Jack"
=Changelog=
;Version 8.6
* Updated: [[#Options|Options]]: improved Excel compatibility
;Version 8.0
