Miller: Like Awk, sed, cut, join, and sort for CSV, TSV, and tabular JSON

Re:Miller: Like Awk, sed, cut, join, and sort for CSV, TSV, ... by networked on Thursday March 16, 2023 @11:08AM (#35182936)

I have made a repository cataloguing tools like this: https://github.com/dbohdan/structured-text-tools.

[ Parent | on HN ]

Re:Miller: Like Awk, sed, cut, join, and sort for CSV, TSV, ... by account-5 on Thursday March 16, 2023 @12:07PM (#35183844)

Thanks for this, good job. I always mean to do something similar but just end up bookmarking HN threads I then never look at.

[ Parent | on HN ]

Re:Miller: Like Awk, sed, cut, join, and sort for CSV, TSV, ... by samstave on Thursday March 16, 2023 @01:10PM (#35184934)

Guilty as charged... I have so many bookmarks I forget to look at...

APPlet Idea: an app that picks a random bookmark from your saves and sends you a reminder to click it and read it... and schedule when you want to see it - like every 7AM send me a link from my bookmarks. Set an alarm for 15 minutes to get me back on schedule.

[ Parent | on HN ]

Re:Miller: Like Awk, sed, cut, join, and sort for CSV, TSV, ... by damascus on Friday March 17, 2023 @02:15PM (#35200772)

So chatgpt and I made this: https://github.com/erasei/randombookmark Load in developer mode and when you click the icon it will open a new tab with a random bookmark.

[ Parent | on HN ]

Re:Miller: Like Awk, sed, cut, join, and sort for CSV, TSV, ... by jefftk on Thursday March 16, 2023 @12:55PM (#35184674)

There's also GoAWK, which supports CSV natively ("-i csv"): https://github.com/benhoyt/goawk

[ Parent | on HN ]

Re:Miller: Like Awk, sed, cut, join, and sort for CSV, TSV, ... by glomgril on Thursday March 16, 2023 @01:08PM (#35184904)

Big shouts to visidata -- very underrated tool imo.

[ Parent | on HN ]

Re:Miller: Like Awk, sed, cut, join, and sort for CSV, TSV, ... by horseRad on Thursday March 16, 2023 @01:56PM (#35185627)

You should include qsv (https://github.com/jqnatividad/qsv) and goawk (https://github.com/benhoyt/goawk) into the CSV section! Goawk got a csv/tsv mode and qsv is loaded with features being developed.

[ Parent | on HN ]

Re:Miller: Like Awk, sed, cut, join, and sort for CSV, TSV, ... by elesiuta on Thursday March 16, 2023 @02:12PM (#35185909)

Thank you! That list is perfect since I don't use these tools often enough to remember them and some are hard to find again without knowing exactly what to search for.

I also discovered pawk on it which looks interesting, I made a somewhat related tool [1] which is probably out of scope for your list, but can be used in some of the same ways [2] and may of of interest nonetheless.

[1] https://github.com/elesiuta/pyxargs

[2] cat /etc/hosts | pyxargs -d \n --im json --pre "d={}" --post "print(dumps(d))" --py "d['{}'.split()[0]] = '{}'.split()[1]"

[ Parent | on HN ]