mainSHELECT - Summary

 
 
Membership Info
Group Admin:
1 active member

Group identification
Id: 11883
System Name: shelect
Name: SHELECT
Group Type: non-GNU software and documentation

Search in this Group


 

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

 

Latest News rss feed

No news found


Communication Tools
 Mailing Lists (0 public mailing lists)

Back to the top

Powered by Savane 3.13-d3ae.
Corresponding source code