NFT - Anybody here provide (or know of ) data scrubbing services? Referral $$$ paid
 

Would prefer to spend $$$ with fellow CPers.

We have 43 databases averaging 50K each that need to be cleaned up.

Seeking consultant.

Referral $$$ paid to your paypal account

Thanks

Let me know what kind of services you need. Are you in the KC Metro?

I got a gal that comes by when I call and cleans my pipes. She's pretty talented, I'm sure she could clean your databases too.......while wearing a french maid outfit.

Shoot me a PM

Can we keep your porn?

Cleaned up how?

This thread had potential.... but alas.

Better call Saul.

If its really bad The Wolf.

<iframe width="560" height="315" src="//www.youtube.com/embed/IgzFPOMjiC8" frameborder="0" allowfullscreen></iframe>

Gonna need more details. Are you looking at something that could be automated or something that requires a manual once-over?

Thank you for your responses.

Here are the details:

We are sending emails to list of insurance agents in all fifty states.

The databases are public records.

The first list we need cleaned up is from WisCONsin. (How the natives pronounce it.)

http://oci.wi.gov/agentlic/agntlist.shtml

Scroll down to bottom of page:

Format 2 - Agents by Company Appointments

There are 17 files. First one is al_1st-al.exe. We figured out how to separate columns, and remove the records without email addresses.

1) We need all the first and last name duplicates removed; and 2) words turned into lower cases.

We would prefer a way to automate this whole process.

If interested, please PM.

Thanks

*1) uniq file > newfile
2) tr '[:upper:]' '[:lower:]' < file > newfile

*(Are you sure you want to remove dupes by name and not just the entire line? If there are two John Smith entries with different info you will lose one. Might be better to remove complete dupe lines instead?)



</pre>

Good catch! Yes.

Thank you!

If you have a bash shell, this will work...

EDIT: This was tested using the "al_1st-al.exe" file from the site you linked to. Only 8 dupe lines are dropped.

fdisk

http://www.midlandhardware.com/thumb...x=350&maxy=350

This should scrub it for you. PM me for paypal fee,



:)

Check your PM. Trying to reach you.

Magnet

Couldn't you just use awk? Instead of cut? awk '{print $(field#)}' | then do the translation from upper to lower