Em Andamento

Simple data extraction

Need to extract data from text based emails into a CSV file.

## Deliverables

Revision 2 July 2008

----------

Based on bids received I have revised my request. Please submit a new quote if you are still interested.

I have discovered that if I select all the emails in the folder and save I get one text file containing all the emails in text format. As the format is identical for each email writing a utility to parse the data to a csv file seems to me to be quite simple.

I cannot supply the raw emails but I have put a couple of samples in a text file (see attached). What I need is a utility/app to do the parsing. I have a few other emails of a similar nature so if this one works it is likely there will be two others that are very similar.

In summary, I would like a revised quote for

1) Parsing the text file data as follows to a single csv file (ie all emails in one file)

The fields will be

Date

Title

FirstName

LastName

OtherName

Street

Suburb

State

Postcode

Contact

Email

Membership No

2) Parsing the scanned emails that have already been printed and deleted from the system. Each page is in the identical format to the emails dumped to the text file.

(Note: the date I need extracted some from ?€œBelow is the result of your feedback form. It was submitted by (Supporter) on Fri Jun 27 02:15:30 EST 2008?€

Please specify how you will handle breaking the name into three field given the different data entry possibilities.

--------------------------------

I have people subscribe online and the results are emailed to me. An example of the email is given below. All the emails have been received in Outlook 2007 in a single folder. I need the details from all the emails in that folder put into a csv file, including the date (not time) it was submitted. I also need first and last name in different fields.

We are in the process of completely redoing our website and membership processing so I only need a quick fix for the emails I have received to date.

Is it possible to create a script I can add to Outlook to extract the data and send to the CSV file?

I also have hundreds of these that have been printed and deleted as my predecessor planned to type the details manually. I thought I might be able to scan and OCR those ones (I hope). I was wondering if this could be solved in a similar way.

Example email

****************************

Below is the result of your feedback form. It was submitted by (Supporter) on Fri Jun 27 02:15:30 EST 2008

---------------------------------------------------------

Title: Mr

____________________________________________

Name: Jack Smith

____________________________________________

Street: 7 Watson Street

____________________________________________

Suburb: Bedford

____________________________________________

State: QLD

____________________________________________

Postcode: 5555

____________________________________________

Contact: 0404 555 555

____________________________________________

Email: someone@[url removed, login to view]

____________________________________________

Membership No.: N/A

____________________________________________

* * *This broadcast message was sent to all bidders on Wednesday Jul 2, 2008 8:38:03 AM:

Based on bids received I have revised my request. Please submit a new quote if you are still interested. I have discovered that if I select all the emails in the folder and save I get one text file containing all the emails in text format. As the format is identical for each email writing a utility to parse the data to a csv file seems to me to be quite simple. I cannot supply the raw emails but I have put a couple of samples in a text file (see attached). What I need is a utility/app to do the parsing. I have a few other emails of a similar nature so if this one works it is likely there will be two others that are very similar. In summary, I would like a revised quote for: 1) Parsing the text file data as follows to a single csv file (ie all emails in one file) The fields will be Date Title FirstName LastName OtherName Street Suburb State Postcode Contact Email Membership No 2) Parsing the scanned emails that have already been printed and deleted from the system. Each page is in the identical format to the emails dumped to the text file. (Note: the date I need extracted some from ?€œBelow is the result of your feedback form. It was submitted by (Supporter) on Fri Jun 27 02:15:30 EST 2008?€ Please specify how you will handle breaking the name into three field given the different data entry possibilities. Regards Carmel

Habilidades: Processamento de Dados, Engenharia, MySQL, PHP, Arquitetura de software, Teste de Software

Ver mais: writing text app, writing fix website, script writing app, online ocr, jack smith, in qld, date utility, data request system, request feedback revision, feedback revision request, online script writing, utility app, script data entry, scan website emails, online data works, ocr app, online data entry works, data entry summary, data entry raw, php save data file, message simple text, text revision online, submit data php simple, script scan email, php parsing text

Acerca do Empregador:
( 4 comentários ) Australia

ID do Projeto: #3015691

Premiar a:

Prashantskin

See private message.

$42.5 USD em 5 dias
(458 Avaliações)
6.9

14 freelancers estão ofertando em média $49 para este trabalho

alexstep

See private message.

$85 USD in 5 dias
(98 Comentários)
6.1
vnb400sl

See private message.

$25.5 USD in 5 dias
(112 Comentários)
5.8
jawadh

See private message.

$85 USD in 5 dias
(76 Comentários)
5.9
aczireonline

See private message.

$46.75 USD in 5 dias
(35 Comentários)
4.9
notvalidalv

See private message.

$63.75 USD in 5 dias
(42 Comentários)
4.6
hassannasirvw

See private message.

$38.25 USD in 5 dias
(21 Comentários)
4.5
abhaysinghb

See private message.

$63.75 USD in 5 dias
(9 Comentários)
3.8
Anbusivam

See private message.

$21.25 USD in 5 dias
(13 Comentários)
3.3
tarikut

See private message.

$25.5 USD in 5 dias
(2 Comentários)
0.8
shahabuddin22vw

See private message.

$42.5 USD in 5 dias
(0 Comentários)
0.0
vw6966053vw

See private message.

$8.5 USD in 5 dias
(0 Comentários)
0.0
abtechsolutions

See private message.

$59.5 USD in 5 dias
(1 Comentário)
0.0
optimusservices

See private message.

$76.5 USD in 5 dias
(0 Comentários)
0.0