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.
Décerné à :
28 freelance ont fait une offre moyenne de 109 $ pour ce travail
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.
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.
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