sponsor Vim development Vim logo Vim Book Ad

rainbow_csv.vim : Highlight columns in csv/tsv files and run SELECT queries in SQL-like language

 script karma  Rating 45/18, Downloaded by 2886  Comments, bugs, improvements  Vim wiki

created by
Dmitry Ignatovich
 
script type
syntax
 
description
Rainbow CSV has 2 main features:

* Highlights csv columns in different rainbow colors.
* Provides SELECT and UPDATE queries in RBQL: SQL-like transprogramming query language.

Demonstration gif:
https://i.imgur.com/Tnk9KZv.gif

There are 2 ways to enable csv columns highlighting:
* CSV autodetection based on file content. File extension doesn't have to be .csv or .tsv
* Manual CSV delimiter selection with :RainbowDelim command (So you can use rainbow_csv for non-table files, e.g. to highlight function arguments in different colors)

To run an RBQL query either press F5 or enter the query in vim command line e.g. :Select a1, a2

More info can be found here: https://github.com/mechatroner/rainbow_csv
 
install details
https://github.com/mechatroner/rainbow_csv
 

rate this script Life Changing Helpful Unfulfilling 
script versions (upload new version)

Click on the package to download.

package script version date Vim version user release notes
rainbow_csv-master.zip 4.3.0 2019-11-12 7.3 Dmitry Ignatovich * Redesigned syntax logic: added support for conventional Vim filetypes
* Support newlines in CSV fields
* Support multicharacter separators
* Updated RBQL
* Bug fixes and usability improvements
rainbow_csv-master.zip 4.0 2018-06-04 7.3 Dmitry Ignatovich Usability improvements
rainbow_csv-master.zip 3.0 2017-10-30 7.3 Dmitry Ignatovich Correct handling of quoted commas; Built-in SQL-like RBQL query language which supports SELECT, TOP, WHERE, ORDER BY, UPDATE, JOIN and other keywords;
rainbow_csv-master.zip 2.0 2016-03-10 7.0 Dmitry Ignatovich Persistent settings for files. Added 'header' feature. See github page for more info.
rainbow_csv.zip 1.0 2013-05-25 7.3 Dmitry Ignatovich Initial upload
ip used for rating: 216.73.216.103

Questions about Vim should go to the maillist. Help Uganda.     Vim at Github