CSV-Viewer

CSV-Viewer is command line csv viewer in Pure Java.

Install

$>  git clone https://github.com/pawarashish564/CSV-Viewer.git
$>  cd CSV-Viewer
$>  javac CSVViewer.java
$>  csv-viewer

From File

using p option

$> csv-viewer -p _example/example.csv

Display Options

Default

 $> csv-viewer -p demo.csv
+=====================+=====+=====+=====+
| Str                 | f1  | f2  | int |
|=====================|=====|=====|=====|
| Witcher             | 7.6 | 7.4 | 7   |
| TBC Hours Mystery   | 4.1 | 4.1 | 3   |
| TBC Hours Mystery-2 | 4.1 | 3.9 | 3   |
| 20/20               | 4.1 | 3.7 | 3   |
| Nightline           | 2.7 | 2.6 | 2   |
| Dateline Friday     | 4.1 | 4.1 | 3   |
| Dateline Sunday     | 3.5 | 3.2 | 3   |
| Life On the Train   | 1.2 | 1.5 | 3   |
| Big Bang Theory     | 9.2 | 9.5 | 9   |
| Demo Cycle          | 1.8 | 5.6 | 1   |
| Colors              | 6.7 | 8.9 | 10  |
| Tech Study          | 8.9 | 8.9 | 8   |
+=====================+=====+=====+=====+

Column Specific

 $> csv-viewer -p demo.csv  -o "f1,int,f2,Str"
 +=====+=====+=====+=====================+
| f1  | int | f2  | Str                 |
|=====|=====|=====|=====================|
| 7.6 | 7   | 7.4 | Witcher             |
| 4.1 | 3   | 4.1 | TBC Hours Mystery   |
| 4.1 | 3   | 3.9 | TBC Hours Mystery-2 |
| 4.1 | 3   | 3.7 | 20/20               |
| 2.7 | 2   | 2.6 | Nightline           |
| 4.1 | 3   | 4.1 | Dateline Friday     |
| 3.5 | 3   | 3.2 | Dateline Sunday     |
| 1.2 | 3   | 1.5 | Life On the Train   |
| 9.2 | 9   | 9.5 | Big Bang Theory     |
| 1.8 | 1   | 5.6 | Demo Cycle          |
| 6.7 | 10  | 8.9 | Colors              |
| 8.9 | 8   | 8.9 | Tech Study          |
+=====+=====+=====+=====================+

JSON Output

$> csv-viewer -p demo.csv -j
[
        {
                "Str":"Witcher",
                "f1":"7.6",
                "f2":"7.4",
                "int":"7"
        },
        {
                "Str":"TBC Hours Mystery",
                "f1":"4.1",
                "f2":"4.1",
                "int":"3"
        },
        {
                "Str":"TBC Hours Mystery-2",
                "f1":"4.1",
                "f2":"3.9",
                "int":"3"
        },
        {
                "Str":"20/20",
                "f1":"4.1",
                "f2":"3.7",
                "int":"3"
        }
]

Limit Option

set display rows num.

 $> csv-viewer -p _example/example.csv -l 2
+===================+=====+=====+=====+
| Str               | f1  | f2  | int |
|===================|=====|=====|=====|
| Witcher           | 7.6 | 7.4 | 7   |
| TBC Hours Mystery | 4.1 | 4.1 | 3   |
+===================+=====+=====+=====+

Filter Option

set display condition.

 $> csv-viewer -p Demo.csv -f "f1 > 3.5"
 +=====================+=====+=====+=====+
| Str                 | f1  | f2  | int |
|=====================|=====|=====|=====|
| Witcher             | 7.6 | 7.4 | 7   |
| TBC Hours Mystery   | 4.1 | 4.1 | 3   |
| TBC Hours Mystery-2 | 4.1 | 3.9 | 3   |
| 20/20               | 4.1 | 3.7 | 3   |
| Dateline Friday     | 4.1 | 4.1 | 3   |
| Big Bang Theory     | 9.2 | 9.5 | 9   |
| Colors              | 6.7 | 8.9 | 10  |
| Tech Study          | 8.9 | 8.9 | 8   |
+=====================+=====+=====+=====+

 $> csv-viewer -p Demo.csv -f "f1 < 3.5"
+===================+=====+=====+=====+
| Str               | f1  | f2  | int |
|===================|=====|=====|=====|
| Nightline         | 2.7 | 2.6 | 2   |
| Life On the Train | 1.2 | 1.5 | 3   |
| Demo Cycle        | 1.8 | 5.6 | 1   |
+===================+=====+=====+=====+

Sorting Options

 $> csv-viewer -p Demo.csv -s "Str"
+=====================+=====+=====+=====+
| Str                 | f1  | f2  | int |
|=====================|=====|=====|=====|
| 20/20               | 4.1 | 3.7 | 3   |
| Big Bang Theory     | 9.2 | 9.5 | 9   |
| Colors              | 6.7 | 8.9 | 10  |
| Dateline Friday     | 4.1 | 4.1 | 3   |
| Dateline Sunday     | 3.5 | 3.2 | 3   |
| Demo Cycle          | 1.8 | 5.6 | 1   |
| Life On the Train   | 1.2 | 1.5 | 3   |
| Nightline           | 2.7 | 2.6 | 2   |
| TBC Hours Mystery   | 4.1 | 4.1 | 3   |
| TBC Hours Mystery-2 | 4.1 | 3.9 | 3   |
| Tech Study          | 8.9 | 8.9 | 8   |
| Witcher             | 7.6 | 7.4 | 7   |
+=====================+=====+=====+=====+

 $> csv-viewer -p Demo.csv -s "Str DESC"
+=====================+=====+=====+=====+
| Str                 | f1  | f2  | int |
|=====================|=====|=====|=====|
| Witcher             | 7.6 | 7.4 | 7   |
| Tech Study          | 8.9 | 8.9 | 8   |
| TBC Hours Mystery-2 | 4.1 | 3.9 | 3   |
| TBC Hours Mystery   | 4.1 | 4.1 | 3   |
| Nightline           | 2.7 | 2.6 | 2   |
| Life On the Train   | 1.2 | 1.5 | 3   |
| Demo Cycle          | 1.8 | 5.6 | 1   |
| Dateline Sunday     | 3.5 | 3.2 | 3   |
| Dateline Friday     | 4.1 | 4.1 | 3   |
| Colors              | 6.7 | 8.9 | 10  |
| Big Bang Theory     | 9.2 | 9.5 | 9   |
| 20/20               | 4.1 | 3.7 | 3   |
+=====================+=====+=====+=====+

Usage

 $> csv-viewer -h
Usage of csviewer:
  -f value
        filter
  -l int
        set max display rows num
  -p string
        set csv file path
  -o "col1,col2 ,.."
        display specific columns
  -s string
        sort by set value
        ex) col [DESC]?
  -j
      for json output

TODO

• Set multi filters
• limit option support in JSON