login about faq

To prove you're not a spammer, email newuser.lgqa@gmail.com with the subject "Account Request" to request an account.


if I had 100 emails,and each one had a consitent field ie: version number and o/s. I would like to extract those two lines into a central csv database and so forth to be able to pivot the data in excel

eg: export details where:

version = and o/s =

the export tool in outlook doesnt accomodate this sop far, and sending to access doesnt work either.

any help would be awesome.

cheers

asked Oct 06 '10 at 08:15

sbc58000's gravatar image

sbc58000
457713

What are you trying to accomplish?

(Oct 06 '10 at 09:16) Seb Seb's gravatar image

im try to accomplish. the emails are error reports, that have the database version, o/s and software verion in it. Ideally i would like this to be extracted into excel, giving an accurate view of who is using what. without having to manually copy and past the data out from each error 9there are hudreds of them )

-thanks

(Oct 07 '10 at 04:52) sbc58000 sbc58000's gravatar image

well you could write a program to look for the information in the email you want... an email is like a text file, basically... so it can be done with the text file operations in most programming languages... i would choose C or C++... but i dont know of any way to do it in outlook directly...

answered Oct 06 '10 at 09:31

trueb's gravatar image

trueb
16.1k54105269

What's a "text file operation" in C or C++?

(Oct 06 '10 at 09:46) Seb Seb's gravatar image

answered Oct 06 '10 at 12:58

r0bErT4u's gravatar image

r0bErT4u
31.0k515672938

i already have a rule to put what I want into a pst. if i can expand on this a little. 100 emails, all of them have 5 lines of data and a lot of other stuff. i need to extract these 5 lines and only these into excel.

(Oct 07 '10 at 03:46) sbc58000 sbc58000's gravatar image
  1. Download curl's IMAP implementation. Takes about 5 minutes.
  2. Write code to retrieve emails. Test code by writing code that displays incoming emails to the console. 30 minutes? Less.
  3. Comment out test code and place a comment to indicate that it's test code, write code (using regular expressions if possible) that parses the contents of the email and sends the desired content to a csv file. Another 30 minutes?

This is extremely optimistic, to the point where a competent programmer who has experience with C and/or C++ code might take about 15-20 minutes to hack something like this together. If you don't know C or C++ and you can't palm it off to someone else, I'm not sure how else I can help you. Hacking up Outlook just seems to me like a silly idea. Too reliant upon Outlook (which isn't really a bad thing, but isn't a good thing either).

answered Oct 07 '10 at 10:06

Seb's gravatar image

Seb
(suspended)

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or __italic__
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported


Tags:

×136
×41
×16
×1

Asked: Oct 06 '10 at 08:15

Seen: 2,464 times

Last updated: Jan 10 '13 at 12:11