Find Jobs
Hire Freelancers

Build Script that Parses .txt, locates unique text and pastes into excel

£20-250 GBP

Completed
Posted about 6 years ago

£20-250 GBP

Paid on delivery
****IMPORTANT**** Please DO NOT bid for project until you have read full description, taken a look at the files and are certain that you can code the script. We will test the script out fully with a small batch before completing project to make sure it operates as defined. In terms of type of script, we thought either a python or node script but are open to other types that operate on the machine locally. We would develop this ourselves but are quite short of time currently so would appreciate help. ****Description****** We have a collection of over 15,000 individual txt files that contain some client information (see attached zipped example file). We need to place the name, surname, country and phone number as entries for each client in a row in an excel spreadsheet (see example again). So as we see it, we need some sort of script that can parse the txt documents 1 buy 1 in a folder, pull the relevant info from that .txt file and paste it as an entry in the spreadsheet. This is the Name, Surname, Country of Residence and Mobile Number. It is important to note though, that the text does not follow a completely defined pattern with some surnames and names being longer than standard as well as. Mobile Telephone numbers also have different formats. We also need this to get done relatively quickly so would be good to have an ETA of 1-2 days.
Project ID: 16344754

About the project

11 proposals
Remote project
Active 6 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
hi sir, i will create a windows desktop software (exe ) that will read each of the txt files and ADD an entry in excel, can do in 2-3 hours starting now, thanks
£23 GBP in 1 day
4.9 (472 reviews)
6.8
6.8
11 freelancers are bidding on average £133 GBP for this job
User Avatar
Hi there I had a look at the sample files and understood how to generate the excel file from by going through each text file in the folder. I can finish this script in 1 or 2 days maximum. BTW, is it a one time job or you need this script for future scrapping too. I can do this easily with php. Looking forward to working with you. Thanks Rinsad
£157 GBP in 2 days
4.9 (577 reviews)
8.5
8.5
User Avatar
Hello sir I read the job description and check the attached file carefully. I am confident with this job and have done similar project before. I am ready to start the work and deliver the script in a day. Best, Jiang
£99 GBP in 1 day
4.9 (129 reviews)
7.6
7.6
User Avatar
Hi.. I am very interested in your project, because I have much experience in such projects. I have good skills with the program language including C/C++, C#, java, php, asp.net, python, VB.NET. So I have expert and smart technic with web scraping (1000 over projects for scraping), automation and bot(500 over projects for automation and bot), selenium, mobile (android, ios native and others). Especially, I am an expert in betting project and gambling games and sites(bet365, bwin, pinnacle, betfair...) ,,, shopping auto buyer(adidas, footlocker, eastbay, supreme and etc) So, I can solve the captcha automatically. Please contact me, then we can discuss about the details and the price. And I am free in recent days, so I can do my best for your project. Thanks.
£166 GBP in 3 days
4.9 (116 reviews)
7.2
7.2
User Avatar
Hi, If you don't mind I would use VBA. The fact the length of the required pieces of information varies is not a problem as there are string that always occur in the text files. So I can say that first name is always between the strings "First Name" and "Middle Name" or the country is always between "Citizenship" and "ID". So these are patterns I can use. In my mind I have a tool that has only one button that opens a file dialog. The user selects a folder and the script will go through every file with .txt extension in the folder and loads the required data into a row of the Excel file. I can do this tomorrow. Regards, Balint Kolosi
£200 GBP in 1 day
5.0 (120 reviews)
6.9
6.9
User Avatar
Hi there, I have read the project details as well as checked txt file and excel file as well. I know the txt file data has placed fussily. This is an easy job for me. I won't take more than 1-1.5 day. Message me, we can discuss over chat.
£230 GBP in 1 day
5.0 (64 reviews)
6.1
6.1
User Avatar
Hi, i'm a professional C# programmer, and i can provide you with that kind of script that will go through txt files and extract relevant data, please let me know if you are interested, thanks.
£120 GBP in 1 day
5.0 (67 reviews)
6.2
6.2
User Avatar
Update: I have completed the script for reading a single file and putting out the values in columns using a combination of macro and excel formulas. If you could ping me i can send the file. Freelancer is not allowing me to attach a file to the proposal. Hi - I understand the team posting the job is a technical group. So instead of me telling about my experience and patents i'll jump straight to the solution. As you said any scripting language would work fine for this. However as you wanted the output in an excel we can probably keep it as an excel macro. While the format of names and phone numbers can be different there is a pattern in the text files. For example: the first line contains Title, FirstName, Middle name, Last name. - Whatever comes between the strings "Title" and "First Name" is the title - Whatever comes between the strings "First Name" and "Middle Name" is the first name - Whatever comes between the strings "Middle Name" and "Last Name" is the Middle name - Whatever comes after the string "Last Name" is the Last name Like this every line has a pattern which can be coded for. Code for one text file and put it in a loop that reads each text file you have your excel ready. As the program itself is going to be a excel macro access to excel cells will be easier too. Hope my solution interests you. Looking forward for an assignment. ETA of 2 days is good enough.
£123 GBP in 3 days
4.9 (27 reviews)
4.8
4.8
User Avatar
Hello. I propose to write the script in Python 3. I have made some assumptions, please confirm that they are fulfilled in your dataset: - data is always preceded by specific token (like 'First Name'); - token order is the same in all the files, e.g. 'Middle Name' is always follows 'First Name' (it is important for data extraction); Also please consider the output format. To produce .xlsx file I will need to use some 3rd party library. Alternatively, output can be made to .csv file. Best regards, Alexander.
£80 GBP in 2 days
5.0 (18 reviews)
4.6
4.6
User Avatar
Not difficult. Simple to do only using Python libraries 'openpyxl' for write the excel file and 're' for parsing the .txt.
£111 GBP in 2 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED KINGDOM
London, United Kingdom
5.0
1
Payment method verified
Member since Feb 3, 2018

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.