Home Discord Chat
Go Back   ChiefsPlanet > Nzoner's Game Room
Reload this Page Misc NFT - Anybody here provide (or know of ) data scrubbing services? Referral $$$ paid
Register FAQDonate Members List Calendar

Reply
Page 1 of 2 1 2
 
Thread Tools Display Modes
Old 10-17-2014, 03:02 PM  
Trivers Trivers is offline
Always ask 'Why?"
 
Join Date: Oct 2011
Location: Two Rivers, Wisconsin
Casino cash: $-967600
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
Posts: 3,007
Trivers is obviously part of the inner Circle.Trivers is obviously part of the inner Circle.Trivers is obviously part of the inner Circle.Trivers is obviously part of the inner Circle.Trivers is obviously part of the inner Circle.Trivers is obviously part of the inner Circle.Trivers is obviously part of the inner Circle.Trivers is obviously part of the inner Circle.Trivers is obviously part of the inner Circle.Trivers is obviously part of the inner Circle.Trivers is obviously part of the inner Circle.
     Reply With Quote
Old 10-17-2014, 03:08 PM   #2
58-4ever 58-4ever is offline
The Collective Unconscious
 
58-4ever's Avatar
 

Join Date: Sep 2005
Location: The OP
Casino cash: $9450422
Let me know what kind of services you need. Are you in the KC Metro?
Posts: 10,436
58-4ever 's phone was tapped by Scott Pioli.58-4ever 's phone was tapped by Scott Pioli.58-4ever 's phone was tapped by Scott Pioli.58-4ever 's phone was tapped by Scott Pioli.58-4ever 's phone was tapped by Scott Pioli.58-4ever 's phone was tapped by Scott Pioli.58-4ever 's phone was tapped by Scott Pioli.58-4ever 's phone was tapped by Scott Pioli.58-4ever 's phone was tapped by Scott Pioli.58-4ever 's phone was tapped by Scott Pioli.58-4ever 's phone was tapped by Scott Pioli.
     Reply With Quote
Old 10-17-2014, 03:08 PM   #3
stumppy stumppy is offline
New and Improved
 
stumppy's Avatar
 

Join Date: Mar 2002
Location: Springfield, Mo.
Casino cash: $-2411410
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.
__________________
“As a nation, we can endure damaging policies for a four-year term. But we cannot survive a president willing to terminate our Constitution”
Posts: 22,359
stumppy is obviously part of the inner Circle.stumppy is obviously part of the inner Circle.stumppy is obviously part of the inner Circle.stumppy is obviously part of the inner Circle.stumppy is obviously part of the inner Circle.stumppy is obviously part of the inner Circle.stumppy is obviously part of the inner Circle.stumppy is obviously part of the inner Circle.stumppy is obviously part of the inner Circle.stumppy is obviously part of the inner Circle.stumppy is obviously part of the inner Circle.
     Reply With Quote
Old 10-17-2014, 03:14 PM   #4
58-4ever 58-4ever is offline
The Collective Unconscious
 
58-4ever's Avatar
 

Join Date: Sep 2005
Location: The OP
Casino cash: $9450422
Shoot me a PM
Posts: 10,436
58-4ever 's phone was tapped by Scott Pioli.58-4ever 's phone was tapped by Scott Pioli.58-4ever 's phone was tapped by Scott Pioli.58-4ever 's phone was tapped by Scott Pioli.58-4ever 's phone was tapped by Scott Pioli.58-4ever 's phone was tapped by Scott Pioli.58-4ever 's phone was tapped by Scott Pioli.58-4ever 's phone was tapped by Scott Pioli.58-4ever 's phone was tapped by Scott Pioli.58-4ever 's phone was tapped by Scott Pioli.58-4ever 's phone was tapped by Scott Pioli.
     Reply With Quote
Old 10-17-2014, 03:15 PM   #5
stonedstooge stonedstooge is offline
Arf! Arf! Arf!
 
stonedstooge's Avatar
 

Join Date: Dec 2007
Location: North
Casino cash: $3794173
Can we keep your porn?
__________________
2013 ADOPT A CHIEF
Eric Kush




"Often is a word I seldom use"--JP
Posts: 25,289
stonedstooge is obviously part of the inner Circle.stonedstooge is obviously part of the inner Circle.stonedstooge is obviously part of the inner Circle.stonedstooge is obviously part of the inner Circle.stonedstooge is obviously part of the inner Circle.stonedstooge is obviously part of the inner Circle.stonedstooge is obviously part of the inner Circle.stonedstooge is obviously part of the inner Circle.stonedstooge is obviously part of the inner Circle.stonedstooge is obviously part of the inner Circle.stonedstooge is obviously part of the inner Circle.
     Reply With Quote
Old 10-17-2014, 04:13 PM   #6
Rain Man Rain Man is offline
Seize life. Be an ermine.
 
Rain Man's Avatar
 

Join Date: Jul 2001
Location: My house
Casino cash: $-702449
VARSITY
Cleaned up how?
__________________
Active fan of the greatest team in NFL history.
Posts: 145,526
Rain Man is obviously part of the inner Circle.Rain Man is obviously part of the inner Circle.Rain Man is obviously part of the inner Circle.Rain Man is obviously part of the inner Circle.Rain Man is obviously part of the inner Circle.Rain Man is obviously part of the inner Circle.Rain Man is obviously part of the inner Circle.Rain Man is obviously part of the inner Circle.Rain Man is obviously part of the inner Circle.Rain Man is obviously part of the inner Circle.Rain Man is obviously part of the inner Circle.
     Reply With Quote
Old 10-17-2014, 04:15 PM   #7
CaliforniaChief CaliforniaChief is offline
#RIPAce
 
CaliforniaChief's Avatar
 

Join Date: Jan 2009
Location: So Cal
Casino cash: $10515899
Posts: 17,470
CaliforniaChief is obviously part of the inner Circle.CaliforniaChief is obviously part of the inner Circle.CaliforniaChief is obviously part of the inner Circle.CaliforniaChief is obviously part of the inner Circle.CaliforniaChief is obviously part of the inner Circle.CaliforniaChief is obviously part of the inner Circle.CaliforniaChief is obviously part of the inner Circle.CaliforniaChief is obviously part of the inner Circle.CaliforniaChief is obviously part of the inner Circle.CaliforniaChief is obviously part of the inner Circle.CaliforniaChief is obviously part of the inner Circle.
     Reply With Quote
Old 10-17-2014, 04:17 PM   #8
TLO TLO is offline
Life is changing..
 
TLO's Avatar
 

Join Date: Jul 2012
Location: NW Missouri
Casino cash: $-2610000
This thread had potential.... but alas.
Posts: 43,120
TLO is obviously part of the inner Circle.TLO is obviously part of the inner Circle.TLO is obviously part of the inner Circle.TLO is obviously part of the inner Circle.TLO is obviously part of the inner Circle.TLO is obviously part of the inner Circle.TLO is obviously part of the inner Circle.TLO is obviously part of the inner Circle.TLO is obviously part of the inner Circle.TLO is obviously part of the inner Circle.TLO is obviously part of the inner Circle.
     Reply With Quote
Old 10-17-2014, 05:09 PM   #9
srvy srvy is offline
Fight, build, win!
 
srvy's Avatar
 

Join Date: Sep 2004
Location: KC
Casino cash: $-2258750
Better call Saul.
Posts: 25,884
srvy is obviously part of the inner Circle.srvy is obviously part of the inner Circle.srvy is obviously part of the inner Circle.srvy is obviously part of the inner Circle.srvy is obviously part of the inner Circle.srvy is obviously part of the inner Circle.srvy is obviously part of the inner Circle.srvy is obviously part of the inner Circle.srvy is obviously part of the inner Circle.srvy is obviously part of the inner Circle.srvy is obviously part of the inner Circle.
     Reply With Quote
Old 10-17-2014, 05:12 PM   #10
srvy srvy is offline
Fight, build, win!
 
srvy's Avatar
 

Join Date: Sep 2004
Location: KC
Casino cash: $-2258750
If its really bad The Wolf.
Posts: 25,884
srvy is obviously part of the inner Circle.srvy is obviously part of the inner Circle.srvy is obviously part of the inner Circle.srvy is obviously part of the inner Circle.srvy is obviously part of the inner Circle.srvy is obviously part of the inner Circle.srvy is obviously part of the inner Circle.srvy is obviously part of the inner Circle.srvy is obviously part of the inner Circle.srvy is obviously part of the inner Circle.srvy is obviously part of the inner Circle.
     Reply With Quote
Old 10-17-2014, 05:14 PM   #11
AustinChief AustinChief is offline
Administrator
 
AustinChief's Avatar
 

Join Date: Aug 2000
Location: Austin
Casino cash: $-764998
Gonna need more details. Are you looking at something that could be automated or something that requires a manual once-over?
Posts: 20,021
AustinChief is obviously part of the inner Circle.AustinChief is obviously part of the inner Circle.AustinChief is obviously part of the inner Circle.AustinChief is obviously part of the inner Circle.AustinChief is obviously part of the inner Circle.AustinChief is obviously part of the inner Circle.AustinChief is obviously part of the inner Circle.AustinChief is obviously part of the inner Circle.AustinChief is obviously part of the inner Circle.AustinChief is obviously part of the inner Circle.AustinChief is obviously part of the inner Circle.
     Reply With Quote
Old 10-24-2014, 03:01 PM   #12
Trivers Trivers is offline
Always ask 'Why?"
 

Join Date: Oct 2011
Location: Two Rivers, Wisconsin
Casino cash: $-967600
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
Posts: 3,007
Trivers is obviously part of the inner Circle.Trivers is obviously part of the inner Circle.Trivers is obviously part of the inner Circle.Trivers is obviously part of the inner Circle.Trivers is obviously part of the inner Circle.Trivers is obviously part of the inner Circle.Trivers is obviously part of the inner Circle.Trivers is obviously part of the inner Circle.Trivers is obviously part of the inner Circle.Trivers is obviously part of the inner Circle.Trivers is obviously part of the inner Circle.
     Reply With Quote
Old 10-24-2014, 04:20 PM   #13
unlurking unlurking is offline
MVP
 
unlurking's Avatar
 

Join Date: Aug 2003
Casino cash: $7737309
*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?)



__________________
Posts: 10,620
unlurking Forgot to Remove His Claytex and Got Toxic Shock Syndrome.unlurking Forgot to Remove His Claytex and Got Toxic Shock Syndrome.unlurking Forgot to Remove His Claytex and Got Toxic Shock Syndrome.unlurking Forgot to Remove His Claytex and Got Toxic Shock Syndrome.unlurking Forgot to Remove His Claytex and Got Toxic Shock Syndrome.unlurking Forgot to Remove His Claytex and Got Toxic Shock Syndrome.unlurking Forgot to Remove His Claytex and Got Toxic Shock Syndrome.unlurking Forgot to Remove His Claytex and Got Toxic Shock Syndrome.unlurking Forgot to Remove His Claytex and Got Toxic Shock Syndrome.unlurking Forgot to Remove His Claytex and Got Toxic Shock Syndrome.unlurking Forgot to Remove His Claytex and Got Toxic Shock Syndrome.
     Reply With Quote
Old 10-24-2014, 04:34 PM   #14
Trivers Trivers is offline
Always ask 'Why?"
 

Join Date: Oct 2011
Location: Two Rivers, Wisconsin
Casino cash: $-967600
Quote:
Originally Posted by unlurking View Post
*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?)

Good catch! Yes.

Thank you!
Posts: 3,007
Trivers is obviously part of the inner Circle.Trivers is obviously part of the inner Circle.Trivers is obviously part of the inner Circle.Trivers is obviously part of the inner Circle.Trivers is obviously part of the inner Circle.Trivers is obviously part of the inner Circle.Trivers is obviously part of the inner Circle.Trivers is obviously part of the inner Circle.Trivers is obviously part of the inner Circle.Trivers is obviously part of the inner Circle.Trivers is obviously part of the inner Circle.
     Reply With Quote
Old 10-24-2014, 04:51 PM   #15
unlurking unlurking is offline
MVP
 
unlurking's Avatar
 

Join Date: Aug 2003
Casino cash: $7737309
If you have a bash shell, this will work...

Code:
cat infile | cut -c101-135,136-160,350-420 | tr '[:upper:]' '[:lower:]' | sed 's/ \s\+/,/g' > outfile
uniq infile outfile
EDIT: This was tested using the "al_1st-al.exe" file from the site you linked to. Only 8 dupe lines are dropped.
__________________

Last edited by unlurking; 10-24-2014 at 06:27 PM..
Posts: 10,620
unlurking Forgot to Remove His Claytex and Got Toxic Shock Syndrome.unlurking Forgot to Remove His Claytex and Got Toxic Shock Syndrome.unlurking Forgot to Remove His Claytex and Got Toxic Shock Syndrome.unlurking Forgot to Remove His Claytex and Got Toxic Shock Syndrome.unlurking Forgot to Remove His Claytex and Got Toxic Shock Syndrome.unlurking Forgot to Remove His Claytex and Got Toxic Shock Syndrome.unlurking Forgot to Remove His Claytex and Got Toxic Shock Syndrome.unlurking Forgot to Remove His Claytex and Got Toxic Shock Syndrome.unlurking Forgot to Remove His Claytex and Got Toxic Shock Syndrome.unlurking Forgot to Remove His Claytex and Got Toxic Shock Syndrome.unlurking Forgot to Remove His Claytex and Got Toxic Shock Syndrome.
     Reply With Quote
Reply
Page 1 of 2 1 2

« Previous Thread | > Nzoner's Game Room < | Next Thread »

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are On
[IMG] code is On
HTML code is On
Forum Jump




All times are GMT -6. The time now is 09:34 PM.

Contact Us - ChiefsPlanet - Archive - Top

This is a test for a client's site.
Fort Worth Texas Process Servers
Covering Arlington, Fort Worth, Grand Prairie and surrounding communities.
Tarrant County, Texas and Johnson County, Texas.
Advertise with us!
Powered by vBulletin® Version 3.8.8
Copyright ©2000 - 2025, vBulletin Solutions, Inc.