Em Andamento

Software or Data processor- Excel to txt (TAB delimited)

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.

Habilidades: Processamento de Dados, Processamento de dados, Edição, Excel

Ver mais: websites that make software, the best data entry company, software websites, on line processing data processing, london data entry, i am in need of a data entry london, file processor, excel data entry form examples, double data entry excel, double data entry, data processing company, data entry processor, data entry form in access, company software, best software for make website, answer tab, best case software, on line processing, data processing website, data entry london on, data entry in london, best data entry websites, websites it software, websites it and software, txt

Acerca do Empregador:
( 3 comentários ) Prague 2, Czech Republic

ID do Projeto: #602951

Premiar a:

zszabo

Hi, Please see PM. Zoltan

$40 USD em 2 dias
(3 Avaliações)
2.2

26 freelancers are bidding on average $74 for this job

FINGERRPRINT

Thank you for this opportunity. Please check PM.

$100 USD in 3 dias
(123 Comentários)
7.1
BDspeed

**PLS CHECK PMB**

$150 USD in 10 dias
(236 Comentários)
6.5
spawar

Hi, I am ready to start work on this project, will make vb program to create the xls file, interested to work with you long term, using high speed internet connection, I have reviewed your text and xls file and I am Mais

$50 USD in 5 dias
(49 Comentários)
5.9
best4best

Please refer PMB.

$50 USD in 3 dias
(102 Comentários)
5.6
nagybatonyi

Such jobs are my daily practice; please see PMB for details! Regards!

$50 USD em 1 dia
(39 Comentários)
5.4
agihcam

Please check PMB for the DEMO file.

$100 USD em 1 dia
(42 Comentários)
5.2
UmarMahmood

Hi, I was able to spot the discrepancies in your Text file 7 hours ago when I first looked at the description and sample files. Now your clarifications have confirmed that observation as well. I wrote the macro spe Mais

$45 USD in 0 dias
(38 Comentários)
4.6
theMagicNumber

Dear sir/madam please refer to your PMB. Thank You.

$55 USD em 1 dia
(5 Comentários)
4.5
Wonderer

Hi, Will be done. Thanks, Al

$80 USD em 1 dia
(18 Comentários)
4.4
FlashBack

please view the PMB

$150 USD in 7 dias
(13 Comentários)
3.9
cdumitru

Hello, I would like to be the one completing your project. Here is my bid. Thank you, Best regards CD

$55 USD em 1 dia
(5 Comentários)
3.2
jainv2007

Hi Pls check PM, Regards, Jain

$75 USD in 2 dias
(2 Comentários)
2.8
raidontech

We have 50 seater capacity and looking for a job. I am unable to download the FINAL file here, kindly send us for the reference. Thanks

$100 USD em 1 dia
(2 Comentários)
1.0
dataspecialists

Yes I got this perfectly every terms. This bid is for 20 files assuming 3000 rows there. We are trusted concerning these work. My team consists of minimum 20 members. Any kind of conversion work we can do for a long te Mais

$150 USD in 20 dias
(0 Comentários)
0.0
ashisha95

please sir give me a work

$50 USD in 30 dias
(0 Comentários)
0.0
lougr464

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.

$40 USD in 10 dias
(0 Comentários)
0.0
Amogola

being a computer expart i think i can handle the work better

$150 USD in 2 dias
(0 Comentários)
0.0
avinash011

Trust me, your project is in safe hands.

$50 USD in 30 dias
(0 Comentários)
0.0
gmherath

I can design a software for this. I 'm doing this as a part time. that is y it takes 20 days. I can give the software within 20 days

$80 USD in 20 dias
(0 Comentários)
0.0
jnooruddin

I need 3 days to finish the project and I want only $30 for that.

$30 USD in 3 dias
(0 Comentários)
0.0