Modules:

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.