2table

2table

Convert JSON to ASCII Table

Install

npm install -g 2table

Usage

Example test.json

[
  {
    "addressLine1": "1333 2ND ST",
    "city": "SANTA MONICA",
    "state": "CA",
    "zip5": "90401",
    "zip4": "4100",
    "info": {
      "carrierRoute": "C002",
      "countyName": "LOS ANGELES",
      "deliveryPoint": "99",
      "checkDigit": "3",
      "cmar": "N"
    }
  },
  {
    "addressLine1": "1333 2ND ST STE 200",
    "city": "SANTA MONICA",
    "state": "CA",
    "zip5": "90401",
    "zip4": "1151",
    "info": {
      "carrierRoute": "C002",
      "countyName": "LOS ANGELES",
      "deliveryPoint": "99",
      "checkDigit": "0",
      "cmar": "N"
    }
  },
  {
    "addressLine1": "1333 2ND ST FL 1",
    "city": "SANTA MONICA",
    "state": "CA",
    "zip5": "90401",
    "zip4": "4104",
    "info": {
      "carrierRoute": "C002",
      "countyName": "LOS ANGELES",
      "deliveryPoint": "99",
      "checkDigit": "9",
      "cmar": "N"
    }
  }
]

Just output the specified fields as columns

cat test.json | 2table "addressLine1,city,state,zip5"

 addressLine1         city          state  zip5  
 1333 2ND ST          SANTA MONICA  CA     90401 
 1333 2ND ST STE 200  SANTA MONICA  CA     90401 
 1333 2ND ST FL 1     SANTA MONICA  CA     90401  

Rename the columns

cat test.json | 2table "addressLine1:Address,city:City,state:State,zip5:ZipCode"

 Address              City          State  ZipCode 
 1333 2ND ST          SANTA MONICA  CA     90401   
 1333 2ND ST STE 200  SANTA MONICA  CA     90401   
 1333 2ND ST FL 1     SANTA MONICA  CA     90401   

Define column width

cat test.json | 2table "addressLine1:Address{width:11},city:City,state:State,zip5:ZipCode"

 Address      City          State  ZipCode 
 1333 2ND ST  SANTA MONICA  CA     90401   
 1333 2ND ST  SANTA MONICA  CA     90401   
 STE 200                                   
 1333 2ND ST  SANTA MONICA  CA     90401   
 FL 1                                      

Define column color

cat test.json | 2table "addressLine1:Address{width:11;color:red},city:City,state:State{color:cyan},zip5:ZipCode"

 Address      City          State  ZipCode 
 1333 2ND ST  SANTA MONICA  CA     90401   
 1333 2ND ST  SANTA MONICA  CA     90401   
 STE 200                                   
 1333 2ND ST  SANTA MONICA  CA     90401   
 FL 1                                      

Nested object

cat test.json | 2table "addressLine1:Address,city:City,state:State,zip5:ZipCode,info:Details[countyName:County,carrierRoute:Route]"

 Address              City          State  ZipCode  Details            
                                                    County       Route 
 1333 2ND ST          SANTA MONICA  CA     90401    LOS ANGELES  C002  
 1333 2ND ST STE 200  SANTA MONICA  CA     90401    LOS ANGELES  C002  
 1333 2ND ST FL 1     SANTA MONICA  CA     90401    LOS ANGELES  C002