csv
CSV files (and other character delimited tables)
This data type can be used for not only CSV files but also TSV (tab separated) or any other exotic characters used as a delimiter.
The CSV parser is configurable via config
(see link below for docs on how to use config
)
» config -> [csv]
{
"comment": {
"Data-Type": "str",
"Default": "#",
"Description": "The prefix token for comments in a CSV table.",
"Dynamic": false,
"Global": false,
"Value": "#"
},
"separator": {
"Data-Type": "str",
"Default": ",",
"Description": "The delimiter for records in a CSV file.",
"Dynamic": false,
"Global": false,
"Value": ","
}
}
csv
application/csv
application/x-csv
text/csv
text/x-csv
Marshal()
SupportedReadArray()
Treats each new line as a new array elementReadArrayWithType()
Treats each new line as a new array element, each element is mini csv
fileReadIndex()
Indexes treated as table coordinatesReadMap()
Works against tables such as the output from ps -fe
ReadNotIndex()
Indexes treated as table coordinatesUnmarshal()
SupportedWriteArray()
Writes a new line per array element*
(generic): generic (primitive)[[ Element ]]
: Outputs an element from a nested structurecast
: Alters the data-type of the previous function without altering its outputconfig
: Query or define Murex runtime settingsformat
: Reformat one data-type into another data-typeint
: Whole number (primitive)jsonl
: JSON Linesselect
: Inlining SQL into shell pipelinesstr
(string): string (primitive)ReadIndex()
(type): Data type handler for the index, [
, builtinReadNotIndex()
(type): Data type handler for the bang-prefixed index, ![
, builtinReadArray()
(type): Read from a data type one array element at a timeWriteArray()
(type): Write a data type, one array element at a timeReadMap()
(type): Treat data type as a key/value structure and read its contentsMarshal()
(type): Converts structured memory into a structured file format (eg for stdio)Unmarshal()
(type): Converts a structured file format into structured memoryThis document was generated from builtins/types/csv/csv_doc.yaml.
This site's content is rebuilt automatically from murex's source code after each merge to the master
branch. Downloadable murex binaries are also built with the website.
Last built on Thu Aug 15 14:38:34 UTC 2024 against commit 50ed9d650ed9d6df391240d3c2c02e623636e508dfcdad1.
Current version is 6.2.4000 which has been verified against tests cases.