Parsing org table from Linux command line

Parsing org table from Linux command line

[ST]

Hello,

I have an org table and its third column are emails. I would like to
send an email from command line (with the "mail" cli tool) to all those
addresses.

1. How do I extract them from the table and pass to CC of "mail"?

2. Is the same possible somehow if I have several tables with different
#+TBLNAMEs: in the same file?

Thank you in advance!

Re: Parsing org table from Linux command line

[John Kitchin]

Check out Listing 7 in
http://pubs.acs.org/doi/pdf/10.1021/acscatal.5b00538.

It is a pretty minimal Python script to get data from a table. You could
then use it to print column 3 to stdout maybe so it could get piped to
mail, or build up some command you can call.

ST writes:

> Hello,
>
> I have an org table and its third column are emails. I would like to
> send an email from command line (with the "mail" cli tool) to all those
> addresses.
>
> 1. How do I extract them from the table and pass to CC of "mail"?
>
> 2. Is the same possible somehow if I have several tables with different
> #+TBLNAMEs: in the same file?
>
> Thank you in advance!


-- 
Professor John Kitchin
Doherty Hall A207F
Department of Chemical Engineering
Carnegie Mellon University
Pittsburgh, PA 15213
412-268-7803
@johnkitchin
http://kitchingroup.cheme.cmu.edu

Re: Parsing org table from Linux command line

[ST]

Thank you very much!

Is py_org_table.py part of a bigger library? Where can I find it?

Thank you!


On Sun, 2017-12-10 at 18:12 -0800, John Kitchin wrote:
> Check out Listing 7 in
> http://pubs.acs.org/doi/pdf/10.1021/acscatal.5b00538.
> 
> It is a pretty minimal Python script to get data from a table. You could
> then use it to print column 3 to stdout maybe so it could get piped to
> mail, or build up some command you can call.
> 
> ST writes:
> 
> > Hello,
> >
> > I have an org table and its third column are emails. I would like to
> > send an email from command line (with the "mail" cli tool) to all those
> > addresses.
> >
> > 1. How do I extract them from the table and pass to CC of "mail"?
> >
> > 2. Is the same possible somehow if I have several tables with different
> > #+TBLNAMEs: in the same file?
> >
> > Thank you in advance!
> 
> 

Re: Parsing org table from Linux command line

[John Kitchin]

I think you just put Listing 7 in a file called py_org_table.py on your
Python path, or you could just integrate it into the script.

ST writes:

> Thank you very much!
>
> Is py_org_table.py part of a bigger library? Where can I find it?
>
> Thank you!
>
>
> On Sun, 2017-12-10 at 18:12 -0800, John Kitchin wrote:
>> Check out Listing 7 in
>> http://pubs.acs.org/doi/pdf/10.1021/acscatal.5b00538.
>> 
>> It is a pretty minimal Python script to get data from a table. You could
>> then use it to print column 3 to stdout maybe so it could get piped to
>> mail, or build up some command you can call.
>> 
>> ST writes:
>> 
>> > Hello,
>> >
>> > I have an org table and its third column are emails. I would like to
>> > send an email from command line (with the "mail" cli tool) to all those
>> > addresses.
>> >
>> > 1. How do I extract them from the table and pass to CC of "mail"?
>> >
>> > 2. Is the same possible somehow if I have several tables with different
>> > #+TBLNAMEs: in the same file?
>> >
>> > Thank you in advance!
>> 
>> 


-- 
Professor John Kitchin
Doherty Hall A207F
Department of Chemical Engineering
Carnegie Mellon University
Pittsburgh, PA 15213
412-268-7803
@johnkitchin
http://kitchingroup.cheme.cmu.edu