mainSHELECT - Summary

Membership Info
Project Admin:
1 active member

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

Search in this Group


This project 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
# c,sum(b)

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

Communication Tools
 Tech Support Manager (open items: 0, total: 0)
  - Browse open items
  - Submit a new item
 Mailing Lists (0 public mailing lists)

Development Tools
 Bug Tracker (open items: 1, total: 1)
  - Browse open items
  - Submit a new item
 Task Manager (open items: 0, total: 0)
  - Browse open items
  - Submit a new item

Back to the top

Powered by Savane 3.4