How can I export subject line only?
PKa...@gmail.com
subject lines of all emails in a folder to a csv or similar file?
Thanks,
Panos
Melchert Fruitema
statement:
> Is there any way or any extension that allows me to export/extract the
> subject lines of all emails in a folder to a csv or similar file?
>
--
Kind regards,
Melchert
MacOS 10.3.9/Firefox 1.5/Thunderbird 1.5
PKa...@gmail.com
I've already look into that and it doesn't serve me. I only need the
subject line and maybe even the timestamp of the email to be exported
something similar to
Hello John, Sat Dec 14 2005 11:57pm
RE: Your request for quote, Sat Dec 14 2005 12:14pm
FW: Funny Email, Sat Dec 14 2005 12:47pm
etc etc. The msf has too much data in and I need to be able to do
this easily rather than locating the msf file and trimming it manually.
Cheers,
Panos
David S
>
> I've already look into that and it doesn't serve me. I only need the
> subject line and maybe even the timestamp of the email to be exported
> something similar to
>
> Hello John, Sat Dec 14 2005 11:57pm
> RE: Your request for quote, Sat Dec 14 2005 12:14pm
> FW: Funny Email, Sat Dec 14 2005 12:47pm
>
> etc etc. The msf has too much data in and I need to be able to do
> this easily rather than locating the msf file and trimming it manually.
>
Perhaps you could use some sort of automatic script in an office
program or something?
When I wanted something tedious done with a very large text file I
wrote myself a program with an pattern or algorithm to sort
everything. Maybe there's an answer in a script file.
David
Andrew DeFaria
grep ^Subject: <folder> | cut -f2- -d' '
--Andrew DeFaria
Photons have mass? I didn't even know they were Catholic.
PKa...@gmail.com
question is where do I put this code in? (forgive me if the question
seems a little to simple for you but the last time I dealt with MS
scripting it was all in bat files).
Andrew DeFaria wrote:
> David S wrote:
> > PKa...@gmail.com wrote:
> >>
> >> I've already look into that and it doesn't serve me. I only need the
> >> subject line and maybe even the timestamp of the email to be exported
> >> something similar to
> >>
> >> Hello John, Sat Dec 14 2005 11:57pm
> >> RE: Your request for quote, Sat Dec 14 2005 12:14pm
> >> FW: Funny Email, Sat Dec 14 2005 12:47pm
> >>
> >> etc etc. The msf has too much data in and I need to be able to do
> >> this easily rather than locating the msf file and trimming it manually.
> >>
> >
> > Perhaps you could use some sort of automatic script in an office
> > program or something?
> >
> > When I wanted something tedious done with a very large text file I
> > wrote myself a program with an pattern or algorithm to sort
> > everything. Maybe there's an answer in a script file.
> >
> > David
> The following worked for me:
>
> grep ^Subject: </folder/> | cut -f2- -d' '
>
> --
>
> Andrew DeFaria <http://defaria.com>
> Photons have mass? I didn't even know they were Catholic.
>
> --------------030601090509030703000201
> Content-Type: text/html; charset=ISO-8859-1
> X-Google-AttachSize: 1674
>
> <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
> <html>
> <head>
> <meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
> <title></title>
> </head>
> <body bgcolor="#ffffff" text="#000000">
> David S wrote:<font color="#999999"></font>
> <blockquote cite="mid1LOdndXh8_YWU1...@mozilla.org"
> type="cite"><a class="moz-txt-link-abbreviated" href="mailto:PKa...@gmail.com">PKa...@gmail.com</a> wrote:
> <br>
> <blockquote type="cite"><br>
> I've already look into that and it doesn't serve me. I only need the
> <br>
> subject line and maybe even the timestamp of the email to be exported
> <br>
> something similar to
> <br>
> <br>
> Hello John, Sat Dec 14 2005 11:57pm
> <br>
> RE: Your request for quote, Sat Dec 14 2005 12:14pm
> <br>
> FW: Funny Email, Sat Dec 14 2005 12:47pm
> <br>
> <br>
> etc etc. The msf has too much data in and I need to be able to do
> <br>
> this easily rather than locating the msf file and trimming it manually.
> <br>
> <br>
> </blockquote>
> <br>
> Perhaps you could use some sort of automatic script in an office
> program or something?
> <br>
> <br>
> When I wanted something tedious done with a very large text file I
> wrote myself a program with an pattern or algorithm to sort everything.
> Maybe there's an answer in a script file.
> <br>
> <br>
> David
> <br>
> </blockquote>
> The following worked for me:<br>
> <blockquote><tt>grep ^Subject: <<i>folder</i>> | cut -f2- -d' '<br>
> </tt></blockquote>
> <pre>-- </pre>
> <a href="http://defaria.com">Andrew DeFaria</a><br>
> <font color="#999999">Photons have mass? I didn't even know they were
> Catholic.</font><br>
> </body>
> </html>
>
> --------------030601090509030703000201--
Andrew DeFaria
Hi Andrew, thanks for the response and that looks like what I want, the question is where do I put this code in? (forgive me if the question seems a little to simple for you but the last time I dealt with MS scripting it was all in bat files).
The equivalent of grep in Windows cmd is find. Type find /? in a command prompt for more info. The equivalent of cut? Well I don't know. It's usually about at this point in my cmd experience that I say screw it and install Cygwin, however I'm sure there is some solution and you are welcome to look for that on your own. Me, I'll stay with Cygwin...
Good luck.
--Andrew DeFaria
Don't tell anyone, but duct tape is The Force. It has a dark side, and a light side, and it binds the Universe together.
PKa...@gmail.com
Thanks for your help, cygwin seems to be a great help.
Regards,
Panos
Andrew DeFaria wrote:
> PKa...@gmail.com wrote:
> > Hi Andrew, thanks for the response and that looks like what I want,
> > the question is where do I put this code in? (forgive me if the
> > question seems a little to simple for you but the last time I dealt
> > with MS scripting it was all in bat files).
> grep and cut are not part of Windows. Personally I use Cygwin -
> extensively - to provide a very Unix like environment that is extremely
> flexible and useful. As you can see I solved your problem in 100
> characters or less.
>
> The equivalent of grep in Windows cmd is find. Type find /? in a command
> prompt for more info. The equivalent of cut? Well I don't know. It's
> usually about at this point in my cmd experience that I say screw it and
> install Cygwin, however I'm sure there is some solution and you are
> welcome to look for that on your own. Me, I'll stay with Cygwin...
>
> Good luck.
>
> --
>
> Andrew DeFaria <http://defaria.com>
> Don't tell anyone, but duct tape is The Force. It has a dark side, and a
> light side, and it binds the Universe together.
>
> --------------040400070901050707020005
> Content-Type: text/html; charset=ISO-8859-1
> X-Google-AttachSize: 1533
>
> <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
> <html>
> <head>
> <meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
> <title></title>
> </head>
> <body bgcolor="#ffffff" text="#000000">
> <a class="moz-txt-link-abbreviated" href="mailto:PKa...@gmail.com">PKa...@gmail.com</a> wrote:<font color="#999999"></font>
> <blockquote
> cite="mid1153722679...@s13g2000cwa.googlegroups.com"
> type="cite">Hi Andrew, thanks for the response and that looks like
> what I want, the question is where do I put this code in? (forgive me
> if the question seems a little to simple for you but the last time I
> dealt with MS scripting it was all in bat files).<br>
> </blockquote>
> grep and cut are not part of Windows. Personally I use Cygwin -
> extensively - to provide a very Unix like environment that is extremely
> flexible and useful. As you can see I solved your problem in 100
> characters or less. <br>
> <br>
> The equivalent of grep in Windows cmd is find. Type find /? in a
> command prompt for more info. The equivalent of cut? Well I don't know.
> It's usually about at this point in my cmd experience that I say screw
> it and install Cygwin, however I'm sure there is some solution and you
> are welcome to look for that on your own. Me, I'll stay with Cygwin...<br>
> <br>
> Good luck.<br>
> <pre>-- </pre>
> <a href="http://defaria.com">Andrew DeFaria</a><br>
> <font color="#999999">Don't tell anyone, but duct tape is The Force. It
> has a dark side, and a light side, and it binds the Universe together.</font>
> </body>
> </html>
>
> --------------040400070901050707020005--