Default delimiters, no column headers: |
| Expression: | let $input := string-join(
("name,city", "Bob,Berlin", "Alice,Aachen"),
char('\n')
)
let $result := parse-csv($input)
return (
$result => $display(),
$result?get(1, 2),
$result?get(2, 2)
) |
|---|
| Result: | {
"columns": (),
"column-index": {},
"rows": ([ "name", "city" ], [ "Bob", "Berlin" ], [ "Alice", "Aachen" ]),
"get": "(: function :)"
},
"city",
"Berlin" |
|---|
Default delimiters, column headers: |
| Expression: | let $input := string-join(
("name,city", "Bob,Berlin", "Alice,Aachen"),
char('\n')
)
let $result := parse-csv($input, { "header": true() })
return (
$result => $display(),
$result?get(1, "name"),
$result?get(2, "city")
) |
|---|
| Result: | {
"columns": ("name", "city"),
"column-index": { "name": 1, "city": 2 },
"rows": ([ "Bob", "Berlin" ], [ "Alice", "Aachen" ]),
"get": "(: function :)"
},
"Bob",
"Aachen" |
|---|
Custom delimiters, no column headers: |
| Expression: | let $options := {
"row-delimiter": "§",
"field-delimiter": ";",
"quote-character": "|"
}
let $input := "|name|;|city|§|Bob|;|Berlin|§|Alice|;|Aachen|"
let $result := parse-csv($input, $options)
return (
$result => $display(),
$result?get(3, 1)
) |
|---|
| Result: | {
"columns": (),
"column-index": {},
"rows": ([ "name", "city" ], [ "Bob", "Berlin" ], [ "Alice", "Aachen" ]),
"get": "(: function :)"
},
"Alice" |
|---|
Supplied column names: |
| Expression: | let $headers := ("Person", "Location")
let $options := { "header": $headers, "row-delimiter": ";" }
let $input := "Alice,Aachen;Bob,Berlin;"
let $parsed-csv := parse-csv($input, $options)
return (
$parsed-csv => $display(),
$parsed-csv?get(2, "Location")
) |
|---|
| Result: | {
"columns": ("Person", "Location"),
"column-index": { "Person": 1, "Location": 2 },
"rows": ([ "Alice", "Aachen" ], [ "Bob", "Berlin" ]),
"get": "(: function :)"
},
"Berlin" |
|---|
Filtering columns, with ragged input and header: true() |
| Expression: | let $input := string-join((
"date,name,city,amount,currency,original amount,note",
"2023-07-19,Bob,Berlin,10.00,USD,13.99",
"2023-07-20,Alice,Aachen,15.00",
"2023-07-20,Charlie,Celle,15.00,GBP,11.99,cake,not a lie"
), char('\n'))
let $options := {
"header": true(),
"select-columns": (2, 1, 4)
}
let $result := parse-csv($input, $options)
return (
$result => $display(),
$result?get(2, "amount")
) |
|---|
| Result: | {
"columns": ("name", "date", "amount"),
"column-index": { "name": 1, "date": 2, "amount": 3 },
"rows": (
[ "Bob", "2023-07-19", "10.00" ],
[ "Alice", "2023-07-20", "15.00" ],
[ "Charlie", "2023-07-20", "15.00" ]
),
"get": "(: function :)"
},
"15.00" |
|---|
Filtering columns, with supplied column map |
| Expression: | let $input := string-join((
"2023-07-20,Alice,Aachen,15.00",
"2023-07-19,Bob,Berlin,10.00,USD,13.99",
"2023-07-20,Charlie,Celle,15.00,GBP,11.99,cake,not a lie"
), char('\n'))
let $options := {
"header": ( "Person", "", "Amount" ),
"select-columns": (2, 1, 4)
}
let $result := parse-csv($input, $options)
return (
$result => $display(),
$result?get(2, "Person"),
$result?get(2, "Amount")
) |
|---|
| Result: | {
"columns": ("Person", "", "Amount"),
"column-index": { "Person": 1, "Amount": 3 },
"rows": ([ "Alice", "2023-07-20", "15.00" ],
[ "Bob", "2023-07-19", "10.00" ],
[ "Charlie", "2023-07-20", "15.00" ]),
"get": "(: function :)"
},
"Bob",
"10.00" |
|---|
Specifying the number of columns explicitly, with header: false() |
| Expression: | let $input := string-join((
"date, name, amount, currency, original amount",
"2023-07-19,Bob, 10.00, USD, 13.99",
"2023-07-20,Alice, 15.00",
"2023-07-20,Charlie, 15.00, GBP, 11.99, extra data"
), char('\n'))
let $options := {
"header": false(),
"select-columns": 1 to 5,
"trim-whitespace" :true()
}
let $result := parse-csv($input, $options)
return (
$result => $display(),
$result?get(4, 3)
) |
|---|
| Result: | {
"columns": (),
"column-index": {},
"rows": (
[ "date", "name", "amount", "currency", "original amount" ],
[ "2023-07-19", "Bob", "10.00", "USD", "13.99" ],
[ "2023-07-20", "Alice", "15.00", "", "" ],
[ "2023-07-20", "Charlie", "15.00", "GBP", "11.99" ]
),
"get": "(: function :)"
},
"15.00" |
|---|
Specifying the number of columns with a number and header: true() |
| Expression: | let $input := string-join((
"date,name,city,amount,currency,original amount,note",
"2023-07-19,Bob,Berlin,10.00,USD,13.99",
"2023-07-20,Alice,Aachen,15.00",
"2023-07-20,Charlie,Celle,15.00,GBP,11.99,cake,not a lie"
), char('\n'))
let $options := { "header": true(), "select-columns": 1 to 6 }
let $result := parse-csv($input, $options)
return (
$result => $display(),
$result?get(3, "original amount")
) |
|---|
| Result: | {
"columns": ("date", "name", "city",
"amount", "currency", "original amount"),
"column-index": {
"date": 1, "name": 2, "city": 3, "amount": 4,
"currency": 5, "original amount": 6
},
"rows": (
[ "2023-07-19", "Bob", "Berlin", "10.00", "USD", "13.99"],
[ "2023-07-20", "Alice", "Aachen", "15.00", "", ""],
[ "2023-07-20", "Charlie", "Celle", "15.00", "GBP", "11.99"]
),
"get": "(: function :)"
},
"11.99" |
|---|