Rainbow CSV: VS Code Extention

1. https://marketplace.visualstudio.com/items?itemName=mechatroner.rainbow-csv

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.

RBQL-Rainbow Query Language