Data scrub
$250-750 USD
Paid on delivery
Data Scrubbing
I am looking for an automated solution to be used continualy with different data sets.
Solution will take a lump of flat files, remove specific files according to criteria within the file name, rename a few delimited sections within the file name, create an excel spredsheet of results.
$200 paid for complete data scrubbing, copy of script file, excel spredsheet of results.
Script must be provided at end of job.
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. The attached file shows the files that would be kept with denoted 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 1-47PM.tiff
NEW NAME: __1952.02.24__Joseph __ E__Robert __Labs.tiff
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
Project ID: #1198658
About the project
19 freelancers are bidding on average $472 for this job
We are a very experienced team who can tackle this task. Please check PMB for more details.
I can create this automated application to parse the flat files, apply some criteria and output the excel file. Thanks, Suresh
I am sure you would be pleased with the quality of my solution. Let me have a look at some sample data from which I could get started NOW.
Hi, I have good 14 yrs of experience of working on .net technologies. I can assure you that you will get a quality delivery from me. Thanks !!
We have expertise in C# and sql with prior experience in developing tools for data transfer and cleansing for healthcare services. We deliver world class solutions for local price but with a global quality.
I have performed similar projects multiple times for 2 Fortune 500 companies. So, you can be confident your data cleaned properly. I look forward
