Hi,
I have a folder of .eml files. They are an exported backup of my gmail account. Each .eml file is a separate email. They can be easily viewed with notepad.
I need to extract these four items. The format is always consistent mixed with other header and body info not needed.
Date:
Member logged in:
Email:
IP:
Date: Sat, 25 Feb 2012 19:25:24 -0700
Member logged in: somemember123
Email: name@gmail.com
IP: 83.121.245.221
Is there a way to scan this folder, have each email (one per row), with column data:
A1=Date:
A2=Member logged in:
A3=Email:
A4=IP:
Some emails may only have the Date: information. Is there a way to automate the process to scan the folder, only extract info if all four bits of information are available, add this data to one email message per row and ignore all other emails without all four bits of data present?
This is way over my head. I know some of you can come up with a formula in your sleep to do this.
I have thousands of emails to extract this data from.
Any help is sincerely appreciated.
Regards,
Terry
I have a folder of .eml files. They are an exported backup of my gmail account. Each .eml file is a separate email. They can be easily viewed with notepad.
I need to extract these four items. The format is always consistent mixed with other header and body info not needed.
Date:
Member logged in:
Email:
IP:
Date: Sat, 25 Feb 2012 19:25:24 -0700
Member logged in: somemember123
Email: name@gmail.com
IP: 83.121.245.221
Is there a way to scan this folder, have each email (one per row), with column data:
A1=Date:
A2=Member logged in:
A3=Email:
A4=IP:
Some emails may only have the Date: information. Is there a way to automate the process to scan the folder, only extract info if all four bits of information are available, add this data to one email message per row and ignore all other emails without all four bits of data present?
This is way over my head. I know some of you can come up with a formula in your sleep to do this.
I have thousands of emails to extract this data from.
Any help is sincerely appreciated.
Regards,
Terry