I do something similar with Excel files using jq (http://stedolan.github.io/jq/)... | Hacker News

Hacker Newsnew | past | comments | ask | show | jobs | submit

sheetjs on Feb 4, 2014 | parent | context | favorite | on: Execute SQL against structured text like CSV or TS...

I do something similar with Excel files using jq (http://stedolan.github.io/jq/) and j (https://npmjs.org/package/j):

    $ j -J sample_data.xlsb tbl | jq 'length'
    3
    $ j -J sample_data.xlsb tbl | jq '[.[]|.id]|max'
    3
    $ j -J sample_data.xlsb tbl | jq '[.[]|.id]|min'
    1
    $ j -J sample_data.xlsb tbl | jq '[.[]|.value]|add'
    18

jq syntax is very terse compared to the equivalent SQL

spullara on Feb 4, 2014 [–]

At the expense of being nearly unintelligible (or writable) without the documentation open. I don't think anyone was trying to make SQL more terse.

Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact