Software Suggestion - Cleaning Data

Jagged55

Power Member
Joined
Mar 27, 2008
Messages
746
Reaction score
260
Can anyone suggest a good piece(s) of software to help with cleaning up lists? I had a couple pieces that were helpful in the past but I lost them all in a hard drive crash :( I have been getting by with Excel but I need something else. Basically I am looking to do the following:

1. compare two txt files....dupe data is erased and a single clean list is spit out

2. search for a specific string and every line that contains it will be deleted from the list (not search and replace)

3. add a string to various parts of a line: beginning, end after a specific word/string

Any help is appreciated...thanks!
 
Can anyone suggest a good piece(s) of software to help with cleaning up lists? I had a couple pieces that were helpful in the past but I lost them all in a hard drive crash :( I have been getting by with Excel but I need something else. Basically I am looking to do the following:

1. compare two txt files....dupe data is erased and a single clean list is spit out

2. search for a specific string and every line that contains it will be deleted from the list (not search and replace)

3. add a string to various parts of a line: beginning, end after a specific word/string

Any help is appreciated...thanks!
How is the information in the text files structured? CSV, TSV, new lines?
 
Mainly just normal text files (no formatting). One piece of data per line (keyword, url, email address etc). Very simple stuff. So to make it clear, just pretend it is lists of email addresses....comparing 2 lists for dupes, deleting all emails from the list that have "hotmail" in them. Thanks.
 
Back
Top