Query CSV files

You can use RQL to query a CSV file:

{
 	Csv.read(file:"./path/to/file.csv") {
	}
}

Options:

  • auto_parser: If true, the parser will attempt to convert input string to native types. If a function, receive the value as argument and return a new value.
  • auto_parse_date: If true, the parser will attempt to convert input string to dates. If a function, receive the value as argument and return a new value. It requires the "auto_parse" option. Be careful, it relies on node.js's Date.parse.
  • columns: if true, will treat the first row as a header row (so you can access properties by name rather than "0" or "1").
  • delimiter: Set the field delimiter. One character only. Defaults to "," (comma).