Utilities
The
page Utilities unites a number
of auxiliary list management tasks each represented by the corresponding
processing mode. Just one of them can be used at a time.
In
each processing mode the result will be stored in the output file; the
input file will remain the same.
Processing
modes
The
following processing modes are available here:
Straight
Append Mode:
Select this mode if you need to join two or more files of any structure.
As the result you will have a solid file, but no additional operations
like sorting, de-duping, etc.
Merge/Sort/De-dupe
- no ‘Cleaning’:
Select this mode if you need to join two or more files and have the result
sorted and de-duped. Each line of each input file will be regarded as a
separate list item. The listease utility will concatenate the input files, sort the
lines within the resulting file alphabetically and remove duplicated
lines. There will be no e-mails/IPs/phones/etc. extracting, because it’s
the job of the Cleaner.
Extract
domains/sort/de-dupe:
Select this mode if you need to have domain names extracted from your
e-mails list and then sort and de-dupe the result. Thus, you will have the
sorted list of domains to which the addresses from your input list belong,
for example:
Input
list:
alex@some.net
alex@yahoo.com
info@my-company.com
jbrown@yahoo.com
joe@aol.com
joe@berlin.de
linform@berlin.de
lisa@aol.com
manager@business.info
news@some.net
nick_127@hotmail.com
Processing
result:
aol.com
berlin.de
business.info
hotmail.com
my-company.com
some.net
yahoo.com
A
small tip for you: you can use the output file as the input domains file
for the Separator (with the
option “Create separated files for the following domains”) or the Utility
(processing mode “Generate address file”).
Extract
usernames/sort/de-dupe:
Similar to the previous but extracts usernames instead of domains – i.
e. the parts of e-mail addresses before the “@” sign. The resulting
list is then sorted and de-duped, for example:
Input
list:
alex@some.net
alex@yahoo.com
info@my-company.com
jbrown@yahoo.com
joe@aol.com
joe@berlin.de
linform@berlin.de
lisa@aol.com
manager@business.info
news@some.net
nick_127@hotmail.com
Processing
result:
alex
info
jbrown
joe
linform
lisa
manager
news
nick_127
A
small tip for you: you can use the output file as the input usernames file
for the Utility (processing
mode “Generate address file”).
Strip
out only these exact characters:
Select this mode if you need to have some character combination completely
removed from your input file. Indicate any text string as the parameter
and the output file will be a copy of the input file but all occurrences
of the indicated string will be deleted.
Add
extension to the end:
Select this mode and indicate a text string as the parameter, and this
text string will be added to the end of each string of the input file
before placing it into the output file.
Add
prefix to the beginning:
Select this mode and indicate a text string as the parameter, and this
text string will be added to the beginning of each string of the input
file before placing it into the output file.
Replace_…_with
…: Use
this processing mode if you need to quickly perform a very common
operation of replacing all occurrences of one text string in the file with
another text string.
Generate
address file:
Use this mode if you have a list of usernames and a list of domains and
need to get a list of all possible e-mail addresses combining these
usernames with these domains. Please make sure that neither usernames nor
domains contain the sign “@”. It will be added automatically during
the processing.
Example:
Usernames
file
lisa
info
smith
Domains
file
aol.com
berlin.de
yahoo.com
Processing
result
info@aol.com
info@berlin.de
info@yahoo.com
lisa@aol.com
lisa@berlin.de
lisa@yahoo.com
smith@aol.com
smith@berlin.de
smith@yahoo.com
Attention!
The number of lines in
the output file will be equal to (the number of usernames)*(the number of
domains). Thus, if you have 2000 usernames and 1000 domains, in the result
you will have 2 000 000 combined e-mail addresses. As you see,
the output files can be really large so please make sure that there is
enough free space on your hard drive before using this feature.
|