More than 5 years have passed since last update.

JSON で任意の要素を jq と sed で TSV にする方法

JSON
sed
jq
TSV

Last updated at 2019-02-20Posted at 2018-01-10


echo '{"dataset_id":"hoge","row_count":"123","table_id":"fuge_20180101"}' | jq -c '{table_id: .table_id, row_count: .row_count}' |sed -e 's/{"table_id":"//g' | sed -e 's/","row_count":"/\t/g' | sed -e 's/"}//g'

echo '[{"dataset_id":"hoge","row_count":"123","table_id":"fuge_20180101"},{"dataset_id":"hoge","row_count":"123","table_id":"fuge_20180101"}]' | jq -c .[]|jq -r '"\(.table_id)\t\(.row_count)"'

You get articles that match your needs
You can efficiently read back useful information
You can use dark theme

What you can do with signing up