data scrub 2

Concluído Postado Oct 28, 2011 Pago na entrega
Concluído Pago na entrega

$200 paid for the following:

1.) data scrubbed to the below sepcifications

2.) copy of the script at the conclusion of the project

3.) excel spredsheet of results

TIMEFRAME:

Must be completed no later than 11-04-2011

* I WILL PAY AN EXTRA $50 IF YOU CAN COMPLETE FOR REVIEW BY 10-31-2011

=================================================================

Here is a sample of the data that needs to be scrubbed. When the name, date of birth, and category (Labs) are all the same, we need to look for the most recent file to keep. The date to use is the one that is NOT in parentheses. In the case where all dates and times are the same use the highest digit found immediately before the 2nd date. Below I have marked the files that would be kept with red arrows.

Additionally, the renaming of the file simply needs to be as follows:

ORGINAL: __1952.02.24__Joseph __ E__Robert __Labs (Jul 21, 2011)__1__Aug 5 2011 [url removed, login to view]

NEW NAME: __1952.02.24__Joseph __ E__Robert [url removed, login to view]

Summary:

• Keep the most recent file

• Identify by 2nd date (not in parentheses)

• If dates are the same go to the time

• If the dates and times are the same, use the highest digit immediately before the 2nd date

SQL

ID do Projeto: #1268580

Sobre o projeto

2 propostas Projeto remoto Ativo em Nov 1, 2011

Concedido a:

barundebnath

as discussed.

$200 USD em 5 dias
(12 Comentários)
4.5

2 freelancers estão ofertando em média $200 nesse trabalho

dataconsultants

Please check PMB for details. Thank you

$200 USD in 2 dias
(7 Comentários)
2.7