Data Mining with Excel

Completed Posted Aug 15, 2012 Paid on delivery
Completed Paid on delivery

I need to search the following values in the text file attached and copy them into Microsoft Excel under the following arrangement:

- Column A: Albert Neo

- Column B: R027949A

- Column C: L3009026J

- Column D: +65 92708121

- Column E: the email address after keyword "mailto:"

Each text file contains 100 of these entries (where the above 5 column data is considered 1 entry).

There are total 150 text files which are equivalent to 15,000 entries.

I am looking for a Microsoft Excel Macro or any software or any formula to complete the task.

Please feel free to PM me for more information.

The text file is attached.
Please feel free to PM me for more information.

Data Entry Data Mining Excel

Project ID: #2405372

About the project

28 proposals Remote project Active Aug 16, 2012

Awarded to:

bcsaba

Think can do this for you fast.

$30 SGD in 0 days
(9 Reviews)
3.4

28 freelancers are bidding on average $109 for this job

vsona

Greetings! Thank you very much for giving us an opportunity to bid for your project. Please refer to PMB for our detailed bid.

$90 SGD in 4 days
(64 Reviews)
5.8
RajHeartbeat

hire me!!..please provide me those 150 txt files..so we can start..Regards..Raj..!

$200 SGD in 7 days
(54 Reviews)
5.7
dataexpobd

Please see PMB

$150 SGD in 3 days
(49 Reviews)
5.5
svteam

Hi, check PM please. Thanks.

$150 SGD in 3 days
(30 Reviews)
5.4
vbexcel

Excel / VBA / data processor pro - ten years experience.

$90 SGD in 1 day
(25 Reviews)
5.3
MDavidCrompton

Hi, Please check feedback and your sample in PM. Needs tidying but it's done

$150 SGD in 1 day
(23 Reviews)
4.9
Nhcuong

Hi I can do this, I'm programmer for year and very familiar with vba in excel. Looking forward to working with you, Cuong NH

$150 SGD in 5 days
(19 Reviews)
4.9
wasimsohail

Please see PM for more details.

$250 SGD in 30 days
(18 Reviews)
4.5
vibearning

I am a c programmer I am successful in automating your task I can do all your 15,000 records Reply me for more

$60 SGD in 2 days
(26 Reviews)
4.4
datasolutionind

Let's Start..........

$100 SGD in 1 day
(17 Reviews)
4.2
hfbaker

I can write a script in perl which will extract name, CEA Registration number, Agency License number, telephone number and email address to 5 columns. I am an expert at data extraction, conversion and formatting with o More

$50 SGD in 1 day
(4 Reviews)
3.7
habayabah

Please read my PM for details of my bid.

$90 SGD in 2 days
(3 Reviews)
3.1
dudu83

Hi, please send me more details if you find myself suitable.

$150 SGD in 3 days
(0 Reviews)
0.0
MatKauton

I can do it for less than a day.

$45 SGD in 1 day
(0 Reviews)
1.1
kautilya7

I understand the requirements of your project. And i am ready to complete it.

$50 SGD in 7 days
(0 Reviews)
0.0
mpvrajan

I am good in excel and i can do this project in time

$100 SGD in 1 day
(0 Reviews)
0.0
basilkeldhose

You want data from text file to be entered into excel file.

$250 SGD in 1 day
(0 Reviews)
0.0
hardwokingguy

My aim is satisfaction to my Client Shared with Work

$30 SGD in 0 days
(0 Reviews)
0.0
SujanM

We are providing excellent admin services since last 7 years. Yes I have macro, formula to complete your project within 10 days. Please read PMB for more detail.

$120 SGD in 10 days
(0 Reviews)
0.0
Prevaron

Hello. Saw your project. Interested in doing it and providing high quality work with precise and accurate data entry. Previous experiance in exact same job.

$200 SGD in 1 day
(0 Reviews)
0.0