Scan your PC for Errors

Member Panel



Join the PC Help Forum Team

Join PC Help Forum on Facebook

Join the PCHF Distributed Computing Teams

Try the NEW PC Help Forum Dark style

Link to PCHF from other parts of the Internet

PC Forum PC Help Forum » Software » Office Software » Parsing email for text

Office Software - Parsing email for text posted in the Software forums; I get a zillion emails a day for a help desk at work. All I really care about from these emails is one field of text that gives me the ...

JOIN US NOW to remove these Ads

I Can Fix This  I Need Help  
  #1  
Old 10-16-2008
Bronze Member
 
Join Date: Oct 2008
Posts: 3
PC Experience: Some Experience
lizbet916 - See this Members User comments on their Profile page
Default Parsing email for text

I get a zillion emails a day for a help desk at work. All I really care about from these emails is one field of text that gives me the error message the customer encountered. Is there a way to extract that one section from all my emails into another file or spreadsheet so I can find all the errors at once? I've tried a few extraction programs (like Data Extractor), but all they do is find the word "error message" and not what the problem actually is. Also, I'm on a tight budget of about $30 since the client will have to pay.

Any help would be GREATLY appreciated!


  #2  
Old 10-17-2008
Jelly Bean's Avatar
Moderation Team Leader
My PC
 
Join Date: Feb 2008
Location: Swansea
Posts: 9,041
PC Experience: I Try My Best.
Jelly Bean - See this Members User comments on their Profile pageJelly Bean - See this Members User comments on their Profile pageJelly Bean - See this Members User comments on their Profile pageJelly Bean - See this Members User comments on their Profile pageJelly Bean - See this Members User comments on their Profile pageJelly Bean - See this Members User comments on their Profile pageJelly Bean - See this Members User comments on their Profile pageJelly Bean - See this Members User comments on their Profile pageJelly Bean - See this Members User comments on their Profile pageJelly Bean - See this Members User comments on their Profile pageJelly Bean - See this Members User comments on their Profile page
Send a message via MSN to Jelly Bean Send a message via Yahoo to Jelly Bean Send a message via Skype™ to Jelly Bean
Default Re: Parsing email for text

Hello and welcome to PCHelpForum.

We have a great Tech Team who will help you with your issue.

I have marked your thread as "Open" in readyness for the team to help you.

JB.


__________________
It is all in the hardware..........................................
Sources:
Microsoft Home Page /Seagate Home Page /Petri Home Page

PCHF Rules / Home Page / Prework /Windows Vista Home Page / XBOX360 / Test your Internet Speed
  #3  
Old 10-17-2008
elpmek's Avatar
Tech Support Team
 
Join Date: Feb 2006
Location: Gloucestershire
Posts: 1,244
PC Experience: Experienced
elpmek - See this Members User comments on their Profile pageelpmek - See this Members User comments on their Profile pageelpmek - See this Members User comments on their Profile pageelpmek - See this Members User comments on their Profile pageelpmek - See this Members User comments on their Profile pageelpmek - See this Members User comments on their Profile pageelpmek - See this Members User comments on their Profile pageelpmek - See this Members User comments on their Profile pageelpmek - See this Members User comments on their Profile pageelpmek - See this Members User comments on their Profile pageelpmek - See this Members User comments on their Profile page
Default Re: Parsing email for text

First what email system are you using?


__________________
  #4  
Old 10-17-2008
Bronze Member
 
Join Date: Oct 2008
Posts: 3
PC Experience: Some Experience
lizbet916 - See this Members User comments on their Profile page
Default Re: Parsing email for text

I'm using Microsoft Outlook. The users fill out a form that includes a section about the error message, which is the only part that is really important for me.


  #5  
Old 10-17-2008
elpmek's Avatar
Tech Support Team
 
Join Date: Feb 2006
Location: Gloucestershire
Posts: 1,244
PC Experience: Experienced
elpmek - See this Members User comments on their Profile pageelpmek - See this Members User comments on their Profile pageelpmek - See this Members User comments on their Profile pageelpmek - See this Members User comments on their Profile pageelpmek - See this Members User comments on their Profile pageelpmek - See this Members User comments on their Profile pageelpmek - See this Members User comments on their Profile pageelpmek - See this Members User comments on their Profile pageelpmek - See this Members User comments on their Profile pageelpmek - See this Members User comments on their Profile pageelpmek - See this Members User comments on their Profile page
Default Re: Parsing email for text

Think of your error messages as SPAM.

In Outlook 2007 I can create as many rules as I like to search through the email's text and if it finds whatever you define it will put it into the Junk folder.

That given I can also put those files, instead into any folder of my creation.

In other words you can move any email to any folder you want depending on the rules you create yourself and it's easy.

If you don't have Outlook 2007, I'm not sure how far this facility goes back 2003? etc.

But it maybe there is a spamfighter application out there that will do the same thing.....


__________________

Last edited by elpmek; 10-17-2008 at 10:21 PM.
  #6  
Old 10-17-2008
Bronze Member
 
Join Date: Oct 2008
Posts: 3
PC Experience: Some Experience
lizbet916 - See this Members User comments on their Profile page
Default Re: Parsing email for text

All of the emails that come into a certain address are all from the help desk, so they all contain information about a customer's problems with the site. So I know which ones will contain the error messages that I can then fix. What I'm hoping, though, is to find a program that can scan these particular emails, find the words "error message" AND everything that follows those words (the entire error message they received and their description of the problem) and move that to a different folder. Basically, to extract the data from a whole list of emails without having to ctl+find the error message from each email and then copy and paste them into another document.

Is this possible?


  #7  
Old 10-17-2008
elpmek's Avatar
Tech Support Team
 
Join Date: Feb 2006
Location: Gloucestershire
Posts: 1,244
PC Experience: Experienced
elpmek - See this Members User comments on their Profile pageelpmek - See this Members User comments on their Profile pageelpmek - See this Members User comments on their Profile pageelpmek - See this Members User comments on their Profile pageelpmek - See this Members User comments on their Profile pageelpmek - See this Members User comments on their Profile pageelpmek - See this Members User comments on their Profile pageelpmek - See this Members User comments on their Profile pageelpmek - See this Members User comments on their Profile pageelpmek - See this Members User comments on their Profile pageelpmek - See this Members User comments on their Profile page
Default Re: Parsing email for text

Originally Posted by lizbet916 View Post
Basically, to extract the data from a whole list of emails.
So you said a form (which is important) arrives, it's got an error message in it (or they all do?)

We can move these emails to a special folder (as per my earlier post)

We now want to extract the user's details and that section of the form containing the error message and subsequent detail. This then leaves us with user and error problem.

At the moment sounds like an Access related query


__________________

I Can Fix This  I Need Help  

Bookmarks

Tags
email, open, parsing, text

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are On

All times are GMT +1. The time now is 11:25 AM.
Powered by vBulletin
Copyright ©2000 - 2009, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.2.0 RC7
All Graphics & Content Copyright © 2004-2009 - PC Help Forum.com

Back to Top