From mboxrd@z Thu Jan  1 00:00:00 1970
From: Greg Minshall <minshall@acm.org>
Subject: (re-)introducing: orgtbl-query (nee org-query)
Date: Tue, 15 Oct 2019 18:40:00 -0400
Message-ID: <112949.1571179200@apollo2.minshall.org>
Mime-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
Return-path: <emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org>
Received: from eggs.gnu.org ([2001:470:142:3::10]:40522)
 by lists.gnu.org with esmtp (Exim 4.90_1)
 (envelope-from <minshall@acm.org>) id 1iKVdv-00076f-KC
 for emacs-orgmode@gnu.org; Tue, 15 Oct 2019 18:50:16 -0400
Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71)
 (envelope-from <minshall@acm.org>) id 1iKVdu-0003DQ-05
 for emacs-orgmode@gnu.org; Tue, 15 Oct 2019 18:50:15 -0400
Received: from hiwela.pair.com ([209.68.5.201]:11580)
 by eggs.gnu.org with esmtp (Exim 4.71)
 (envelope-from <minshall@acm.org>) id 1iKVdt-0003Ch-Sr
 for emacs-orgmode@gnu.org; Tue, 15 Oct 2019 18:50:13 -0400
Received: from hiwela.pair.com (localhost [127.0.0.1])
 by hiwela.pair.com (Postfix) with ESMTP id A027F98050E
 for <emacs-orgmode@gnu.org>; Tue, 15 Oct 2019 18:41:33 -0400 (EDT)
Received: from minshall-entroware-apollo.cliq.com (unknown [108.211.200.94])
 (using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 (256/256 bits))
 (No client certificate requested)
 by hiwela.pair.com (Postfix) with ESMTPSA id 919248F084A
 for <emacs-orgmode@gnu.org>; Tue, 15 Oct 2019 18:41:33 -0400 (EDT)
Received: from apollo2.minshall.org (localhost [IPv6:::1])
 by minshall-entroware-apollo.cliq.com (Postfix) with ESMTP id EEBA360E10
 for <emacs-orgmode@gnu.org>; Tue, 15 Oct 2019 18:40:00 -0400 (EDT)
Content-ID: <112948.1571179200.1@apollo2.minshall.org>
List-Id: "General discussions about Org-mode." <emacs-orgmode.gnu.org>
List-Unsubscribe: <https://lists.gnu.org/mailman/options/emacs-orgmode>,
 <mailto:emacs-orgmode-request@gnu.org?subject=unsubscribe>
List-Archive: <https://lists.gnu.org/archive/html/emacs-orgmode>
List-Post: <mailto:emacs-orgmode@gnu.org>
List-Help: <mailto:emacs-orgmode-request@gnu.org?subject=help>
List-Subscribe: <https://lists.gnu.org/mailman/listinfo/emacs-orgmode>,
 <mailto:emacs-orgmode-request@gnu.org?subject=subscribe>
Errors-To: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org
Sender: "Emacs-orgmode"
 <emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org>
To: emacs-orgmode@gnu.org

apologies for the extra noise.

i've renamed (and moved) my small utility, now known as orgtbl-query,
that allows one to query, from the shell (command line), the contents of
an org-mode table in a file.  orgtbl-query is now located at:
----
https://gitlab.com/minshall/orqtbl-query
----
part of it has also been re-written in C for performance reasons (a
makefile is included); apologies for making it that much harder to
install.  (the awk part remains.)

it works for my use cases (obviously), but i'm sure it will break, or be
feature-deficient, for those of others.  i'd be happy to try to fix
bugs.  below are the first N lines of help output.

cheers, Greg

----
usage: orgtbl-query -h|--help
     : orgtbl-query [-f|--field column] [--complement] [--regexp]
                                        [--ignore-case] file [[table:]colu=
mn] key
     : orgtbl-query -t|--tables file
     : orgtbl-query -c|--columns file [table[:]]
     : orgtbl-query -k|--keys file [[table:]column]
----
the first form prints this help message

the second form searches for KEY in FILE, TABLE, COLUMN, and prints out
any matching lines (or a single column).  tables are named, as in emacs
org-mode, "#+name: TABLE", starting in column one

the third form lists all the tables in FILE

the fourth form lists all the columns in a single TABLE in FILE

the fifth form lists the keys in column COLUMN of the table TABLE in FILE

...