En cours

Data Mining with Excel

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.

Compétences : Saisie de Données, Exploitation de Données, Excel

Voir plus : excel keyword mining, data mining excel, text mining excel, microsoft excel software, data entry macro, text mining excel macro, microsoft macro, macro e, excel formula, email mining, data mining software, albert, excel contains, microsoft software macro, mining text data, macro formula, data arrangement excel, excel text column, microsoft excel macro, excel column copy, macro address, macro data entry, excel macro address, excel copy values, macro values

Concernant l'employeur :
( 16 commentaires ) Singapore, Singapore

N° du projet : #2405372

Décerné à :

bcsaba

Think can do this for you fast.

30 $ SGD en 0 jours
(9 Commentaires)
3.4

28 freelance ont fait une offre moyenne de 109 $ pour ce travail

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 en 4 jours
(64 Commentaires)
5.8
RajHeartbeat

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

200 $ SGD en 7 jours
(54 Commentaires)
5.7
dataexpobd

Please see PMB

150 $ SGD en 3 jours
(49 Commentaires)
5.5
svteam

Hi, check PM please. Thanks.

150 $ SGD en 3 jours
(30 Commentaires)
5.4
vbexcel

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

90 $ SGD en 1 jour
(25 Commentaires)
5.3
MDavidCrompton

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

150 $ SGD en 1 jour
(23 Commentaires)
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 en 5 jours
(19 Commentaires)
4.9
wasimsohail

Please see PM for more details.

250 $ SGD en 30 jours
(18 Commentaires)
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 en 2 jours
(26 Commentaires)
4.4
datasolutionind

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

100 $ SGD en 1 jour
(17 Commentaires)
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 Plus

50 $ SGD en 1 jour
(4 Commentaires)
3.7
habayabah

Please read my PM for details of my bid.

90 $ SGD en 2 jours
(3 Commentaires)
3.1
MrImperium

Hi Sir, I am an etl developer and this type of work is my bread and butter.In programming you can use the denormalize function to get the desired results. Please see my pmb for further detail.

100 $ SGD en 2 jours
(1 Commentaire)
1.8
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 en 10 jours
(0 Commentaires)
0.0
dudu83

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

150 $ SGD en 3 jours
(0 Commentaires)
0.0
anjalee89

i want to apply for this job.i guarantee you if u grant me a chance i'll do my best in good quality & timely.

100 $ SGD en 7 jours
(0 Commentaires)
0.0
freelancercochin

hi, Im intrested to do this job

100 $ SGD en 5 jours
(0 Commentaires)
0.0
coolkappa

Dear Sir I would like to work with you. I dont have any feedback since I have not started any job. You can make the payment once the job is successfully completed. Looking for a response from you Thanx in Advance

80 $ SGD en 4 jours
(0 Commentaires)
0.0
pradnyajoshi

Hello, I am an analyst with experience in Excel, Access and SQL Server. Looking at the file you provided, it is possible to create a macro to extract data from the file. I can provide you the macro for one f Plus

50 $ SGD en 1 jour
(0 Commentaires)
0.0
hardwokingguy

My aim is satisfaction to my Client Shared with Work

30 $ SGD en 0 jours
(0 Commentaires)
0.0