Network Automation Software We are currently migrating this forum
over to our HelpSystems domain. Please
post all new threads in our new
HelpSystems Community Portal.
Post to the HelpSystems Forum
You are not currently logged on. You must be logged on in order to post. Log on
Or Create a new account
AutoMate Discussion
Decrease font size
Increase font size
Topic Title: Extract email addresses from a 'spam report'
Topic Summary:
Created On: 03/15/2012 01:44 PM
Status: Read Only
Linear : Threading : Single : Branch
 Extract email addresses from a 'spam report'   - RobertCox - 03/15/2012 01:44 PM  
 Extract email addresses from a 'spam report'   - JeanDelfosse - 03/16/2012 12:19 AM  
 Extract email addresses from a 'spam report'   - RobertCox - 03/16/2012 02:53 AM  
 Extract email addresses from a 'spam report'   - JeanDelfosse - 03/16/2012 03:18 AM  
 Extract email addresses from a 'spam report'   - RobertCox - 03/16/2012 04:02 AM  
 Extract email addresses from a 'spam report'   - JeanDelfosse - 03/16/2012 05:25 AM  
 Extract email addresses from a 'spam report'   - RobertCox - 03/16/2012 10:03 AM  
 Extract email addresses from a 'spam report'   - JeanDelfosse - 03/16/2012 11:01 AM  
 Extract email addresses from a 'spam report'   - RobertCox - 03/16/2012 01:58 PM  
 Extract email addresses from a 'spam report'   - JeanDelfosse - 03/16/2012 02:27 PM  
 Extract email addresses from a 'spam report'   - RobertCox - 03/20/2012 02:36 AM  
 Extract email addresses from a 'spam report'   - RobertCox - 03/20/2012 02:15 PM  
 Extract email addresses from a 'spam report'   - JeanDelfosse - 03/20/2012 09:52 PM  
Search Topic Search Topic
Topic Tools Topic Tools
View similar topics View similar topics
View topic in raw text format. Print this topic.
Answer This question was answered by RobertCox, on Tuesday, March 20, 2012 2:15 PM

Answer:
Hi Jean

Many thanks, I have this working now!
 03/15/2012 01:44 PM
User is offline View Users Profile Print this message

Author Icon
RobertCox
Apprentice (20-49)

Posts: 41
Joined: 06/29/2005

Hi

I need to extract just the email email addresses contained in a 'Spam Report CSV file'.

Any assistance will be greatly appreciated...

The file usually looks like this (but can be bigger or smaller depending on spam complaints);



"User","Domain","Complaint Date","Complaint Source","Message Type","Date Sent","From","To","Subject","Message-ID","Sendmail ID","Server Outbound IP"
"enqsys@luxhv.com","luxhv.com","March 13, 2012 05:36:01 P.M.","Hotmail","Outbound SMTP: Processed","March 12, 2012 10:07:27 A.M.","sales@the-cruise-specialists.co.uk","washingtonsue@hotmail.com","From £589pp - Getaway with Royal Caribbean
","<201203121603.q2CG39Uh032429@rs85.luxhv.com>","q2CG3qMM032612","66.135.32.36"
"enqsys@luxhv.com","luxhv.com","March 13, 2012 05:12:07 P.M.","Hotmail","Outbound SMTP: Processed","March 13, 2012 08:21:29 A.M.","sales@the-cruise-specialists.co.uk","kloxtoby@hotmail.co.uk","£699 P&O Caribbean Cruise Getaway
","<201203131303.q2DD37w5002149@rs85.luxhv.com>","q2DD3veo002498","66.135.32.36"
"enqsys@luxhv.com","luxhv.com","March 13, 2012 04:07:38 P.M.","Hotmail","Outbound SMTP: Processed","March 13, 2012 08:22:27 A.M.","sales@the-cruise-specialists.co.uk","mary_ward40@hotmail.com","£699 P&O Caribbean Cruise Getaway
","<201203131312.q2DDC61U007447@rs85.luxhv.com>","q2DDCvVp007686","66.135.32.36"
"enqsys@luxhv.com","luxhv.com","March 13, 2012 02:47:04 P.M.","Hotmail","Outbound SMTP: Processed","March 13, 2012 08:16:51 A.M.","sales@the-cruise-specialists.co.uk","desanddi@hotmail.com","£699 P&O Caribbean Cruise Getaway
","<201203131236.q2DCaLgG018627@rs85.luxhv.com>","q2DCavCA018884","66.135.32.36"

 Category Survey
AutoMate 6 version: 6.0.0
Windows version: Windows Vista
Statistics
18258 users are registered to the AutoMate Discussion forum.
There are currently 0 users logged in.
The most users ever online was 6686 on 11/01/2020 at 01:24 AM.
There are currently 3556 guests browsing this forum, which makes a total of 3556 users using this forum.

FuseTalk Enterprise Edition v4.0 - © 1999-2020 FuseTalk Inc. All rights reserved.

Sitemap Network Automation Software Blog