Data Mining with Excel

Fertiggestellt Veröffentlicht Aug 15, 2012 Bezahlt bei Lieferung
Fertiggestellt Bezahlt bei Lieferung

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.

Datenerfassung Datensuche Excel

Projekt-ID: #2405372

Über das Projekt

28 Vorschläge Remote Projekt Aktiv Aug 16, 2012

Vergeben an:

bcsaba

Think can do this for you fast.

$30 SGD in 0 Tagen
(9 Bewertungen)
3.4

28 Freelancer bieten im Durchschnitt $109 für diesen 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 Tagen
(64 Bewertungen)
5.8
RajHeartbeat

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

$200 SGD in 7 Tagen
(54 Bewertungen)
5.7
dataexpobd

Please see PMB

$150 SGD in 3 Tagen
(49 Bewertungen)
5.5
svteam

Hi, check PM please. Thanks.

$150 SGD in 3 Tagen
(30 Bewertungen)
5.4
vbexcel

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

$90 SGD in 1 Tag
(25 Bewertungen)
5.3
MDavidCrompton

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

$150 SGD in 1 Tag
(23 Bewertungen)
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 Tagen
(19 Bewertungen)
4.9
wasimsohail

Please see PM for more details.

$250 SGD in 30 Tagen
(18 Bewertungen)
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 Tagen
(26 Bewertungen)
4.4
datasolutionind

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

$100 SGD in 1 Tag
(17 Bewertungen)
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 Mehr

$50 SGD in 1 Tag
(4 Bewertungen)
3.7
habayabah

Please read my PM for details of my bid.

$90 SGD in 2 Tagen
(3 Bewertungen)
3.1
dudu83

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

$150 SGD in 3 Tagen
(0 Bewertungen)
0.0
MatKauton

I can do it for less than a day.

$45 SGD in 1 Tag
(0 Bewertungen)
1.1
kautilya7

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

$50 SGD in 7 Tagen
(0 Bewertungen)
0.0
mpvrajan

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

$100 SGD in 1 Tag
(0 Bewertungen)
0.0
basilkeldhose

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

$250 SGD in 1 Tag
(0 Bewertungen)
0.0
hardwokingguy

My aim is satisfaction to my Client Shared with Work

$30 SGD in 0 Tagen
(0 Bewertungen)
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 Tagen
(0 Bewertungen)
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 Tag
(0 Bewertungen)
0.0