How to Convert TSV to JSON using command line

In most of the provided dataset we have a need arises to convert it to the JSON format.
here I am demonstrating you a simple and useful approach to achieve that.

We have sample input data as follows:

ord_status.tsv

5 2 3
111 109 2
21 12 9

it's basically a data from some e-commerce application which state the order qty, ship qty and back order qty of particular item.now it's turn to convert it to the JSON document

$: export FIELDS=ord_qty,shp_qty,backord_qty
$: cat ord_status.tsv| ruby -rjson -ne 'puts ENV["FIELDS"].split(",").zip($_.strip.split("\t")).inject({}){|h,x| h[x[0]]=x[1];h}.to_json'

here is the outcome

{"ord_qty":"5","shp_qty":"2","backord_qty":"3"}
{"ord_qty":"111","shp_qty":"109","backord_qty":"2"}
{"ord_qty":"21","shp_qty":"12","backord_qty":"9"}

Java API for JSON Processing (JSR 353) : JsonGenerator and JsonObjectBuilder

Java API for JSON Processing (JSR 353) cleared Public Review unanimously and is on its way to to standardization. There is still Proposed Final Draft and the final vote to come. As per the Java EE 7 schedule, the specification will be final on 4/15/2013. The implementation is already integrated in GlassFish 4 builds.

The API provides an Object Model (like DOM for XML) and Streaming API (like StAX for XML) to parse and generate JSON structure. Here is a table that provide code fragments for generating some common JSON:

JSON	Object Model API	Streaming API
{ }	JsonObject jsonObject =      new JsonObjectBuilder().build(); new JsonWriter(System.out)      .writeObject(jsonObject);	JsonGeneratorFactory factory =      Json.createGeneratorFactory(); JsonGenerator gen =      factory.createGenerator(System.out); gen.writeStartObject().writeEnd();
{   "apple":"red",   "banana":"yellow" }	new JsonObjectBuilder()   .add("apple", "red")   .add("banana", "yellow") .build();	gen.writeStartObject()      .write("apple", "red")      .write("banana", "yellow")    .writeEnd();
[   { "apple":"red" },   { "banana":"yellow" } ]	JsonArray jsonArray = new JsonArrayBuilder()   .add(new JsonObjectBuilder()           .add("apple","red"))   .add(new JsonObjectBuilder()           .add("banana","yellow"))   .build();	gen.writeStartArray()      .writeStartObject()        .write("apple", "red")      .writeEnd()      .writeStartObject()        .write("banana", "yellow")      .writeEnd() .writeEnd();
{   "title":"The Matrix",   "year":1999,   "cast":[     "Keanu Reaves",     "Laurence Fishburne",     "Carrie-Anne Moss"   ] }	new JsonArrayBuilder()   .add(new JsonObjectBuilder()   .add("title", "The Matrix")   .add("year", 1999)   .add("cast", new JsonArrayBuilder()   .add("Keanu Reaves")   .add("Laurence Fishburne")   .add("Carrie-Anne Moss"))) .build();	gen.writeStartObject()      .write("title", "The Matrix")      .write("year", 1999)      .writeStartArray("cast")        .write("Keanu Reaves")        .write("Laurence Fishburne")        .write("Carrie-Anne Moss")      .writeEnd()    .writeEnd();