3 ms·
If you want to run joins on text tables, the coreutils have a "join" tool. You already have it installed: https://www.gnu.org/software/coreutils/manual/html_no
by dima55 4y ago
If you want to run joins on text tables, the coreutils have a "join" tool. You already have it installed:
https://www.gnu.org/software/coreutils/manual/html_node/join-invocation.html https://www.gnu.org/software/coreutils/manual/html_node/join...
And to improve the ergonomics, the vnlog wrappers are available to operate on field names, while retaining the internals of the core tools:
https://github.com/dkogan/vnlog/ https://github.com/dkogan/vnlog/
- zokier 4y agoWhile mentioning alternatives, xsv[1] can do joins on csv files instead of doing naive comma splitting. Also unlike gnu join, xsv does not require input to be sorted (afaik) [1] https://github.com/BurntSushi/xsv https://github.com/BurntSushi/xsv
- sargstuff 4y agogawk/awk can be coded/programmed to do joins on data in cvs files without having to sort input first.
- sargstuff 4y agoawk/gawk can be setup to associate field numbers with field names (via command line, from file, or user input)
- sargstuff 4y agoUmm... guess need to set up a git repository containing the same system written with a)shell/unix tools b) awk/gawk for a separate hn comparison discussion.