Supported separators
| Language name | Separator | Extension | Properties |
|---|---|---|---|
| csv | , (comma) | .csv | Ignored inside double-quoted fields |
| tsv | \t (TAB) | .tsv .tab | |
| csv (semicolon) | ; (semicolon) | Ignored inside double-quoted fields | |
| csv (whitespace) | whitespace | Consecutive whitespaces are merged | |
| csv (pipe) | | (pipe) | ||
| csv (...) | ~ ^ : " = . - |
Content-based separator autodetection
SQL-like "RBQL" query language
Rainbow CSV has built-in RBQL query language interpreter that allows you to run SQL-like queries using a1, a2, a3, ... column names.
Example:
SELECT a1, a2 * 10 WHERE a1 == "Buy" && a4.indexOf('oil') != -1 ORDER BY parseInt(a2), a4 LIMIT 100
To enter query-editing mode, execute RBQL VSCode command.