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

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

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

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

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.

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

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.

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.

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.

Not difficult. Simple to do only using Python libraries 'openpyxl' for write the excel file and 're' for parsing the .txt.