SHELECT - Summary

This group is not part of the GNU Project.

A shell command acting as a simple SQL like agregator for the join, cut and sort unix commands operating on text files. Example:

 $  printf "# a,b,c\nx,3,a\nz,1,a\ny,8,a\nw,10,b\n" | \
       tee /dev/stderr |
      SHELECT c "sum(b)" FROM - WHERE 'a<"z"' GROUP BY c

should output:

# a,b,c
x,3,a
z,1,a
y,8,a
w,10,b
# c,sum(b)
a,11
b,10

The tables are simple text files, one line per record, each column separated by the separator ','.  Lines begining with '#' are comments. The first line must be a comment containing the column names separated by... the separator.

SHELECT is a single file bash script, written for the fun, nevertheless usefull.

Registration Date: Fri 07 Dec 2018 07:04:34 PM UTC
License: GNU General Public License v3 or later
Development Status: 5 - Production/Stable