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
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
here is the outcome
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"}