Often we have to work with JSON data sets, now and then data comes on CSV format. I received a great tip from @diegodellera who told me about textql - Execute SQL against structured text like CSV or TSV.
Those are the steps to install on my MacOSX which
2- Download, compile textql and create a symlink to add to shell PATH:
3- Use the
console to understand the data:
4- Then you can use this as part of an script
Thanks Paul Bergeron for this tool!