Getting data in a text-like format gets you a whole world of weird tools to manage and process it.
Some of the popular ones are
jq allowing you to
parse json instead of TSV.
It claims to be “like sed for JSON data – you can use it to slice and filter
and map and transform structured data with the same ease that sed, awk, grep and friends let you play with text.”
pxi has a cure nerdy introduction;
It is a fast way of executing tony jacascript snippets over streaming data.
Sometimes just examining it is enough; one can use pretty-print-json for that.
yq aspires to be “the
YAML is a superset of JSON, so I guess this gets you everything?
fx is another JSON processor whose remarkable features is a clickable interactive mode.
Consider also, perhaps,
tab … a modern text processing language that’s similar to awk in spirit. (But not similar in implementation or syntax.)
- Designed for concise one-liner aggregation and manipulation of tabular text data…
- Feature-rich enough to support even very complex queries. (Also includes a good set of mathematical operations.)
- Statically typed, type-inferred, declarative.
confbase-scheme is a tool to infer schemas for semi-structured data.