In Progress

data scrub 2

$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

Skills: SQL

See more: sql data, renaming, renaming i, file renaming, excel digit, excel sample project data, excel summary results, script excel sql, simply data excel, scrub file excel, scrub files excel, tiff excel, tiff files, scrub data file excel, script excel files, scrub excel files, copy digit, scrub data, simply data, data scrub file, summary excel, excel summary, renaming files, scrub excel file data, scrub data files excel

About the Employer:
( 2 reviews ) tampa, United States

Project ID: #1268580

Awarded to:

barundebnath

as discussed.

$200 USD in 5 days
(12 Reviews)
4.5

2 freelancers are bidding on average $200 for this job

dataconsultants

Please check PMB for details. Thank you

$200 USD in 2 days
(7 Reviews)
2.7