Hi all bidders,
I am looking for a data processing team able to transform rough data in the form of excel to a TAB delimited .txt format files. They will be for different websites therefore each file will have some things that will vary from one file to another. A sample of a rough format excel file and a finished txt file is provided with this project for your consultation.
From the rough format some values will be ignored completely.
Examples of expected:
If you look at row 4 and 5 in the excel sheet, all information is the same except for the phone number, in that case only the phone number will be used in row 5 as you see on line 40 of the txt file.
If you look at row 38 and 39 from the excel file, the company name is the same but addresses are different. In this case the outcome is different as you can see on line 430 to 454 in the txt file.
The example used is for the website [url removed, login to view]
Please analyse the two files and understand the transition required, I will answer any question you might need answered. Some excel files have as much as 3000 rows in which case every 90 rows will have a different ending as follows: 1st 90 will have an SF ending ".beauty-salons-in-london.tel" further refered as domain name as each file will have a different one. The 91st row to 180 will have an ending of ".pg2.domainname" in this example ".pg1.beauty-salons-in-london.tel". the following 90 i.e. 181 to 270th row will have ending ".pg3.domainname" in this example ".pg3.beauty-salons-in-london.tel"
If for example the 90th and 91st row is the same company the ending will only change with the next company. Notice that the SF value before the ending has no . , " or ' nor does it have double -
There will be 20 such excel files for you to do for now. If everything is done perfectly there will be much more to come.
If someone can make a software for this it would be the best but data processing will be fine as well.
The excel file can also be provided in Access.
*** IMPORTANT ***
I was just informed of a mistake in the txt file concerning row 38, 39 from the excel file. Please find the correct txt file attached below. named UPDATED-Beauty Salons.txt1.
Thanks for understanding and for bidding!
*** VERY IMPORTANT ***
I present my aplogies to all the bidders, it seems that there were some further mistakes so I am uploading the final update. Please find the txt file names FINAL UPDATE.txt
Thanks for understanding and cooperation
Please also pay attention to the FT lines for example Line 9 and line 22 from the txt file as the last two keywords are changing from one entry to another.
26 freelancers are bidding on average $74 for this job
I am very proficient in not only Data Entry but also in Excel and Word. I would be happy to provide you the services that you need and do it in a timely manner.