Download ASCII Key for Windows 7 - Excel macro comparing text files by columns

ASCII Key 1.3

Excel macro comparing text files using only selected columns for the compare

ASCII Key is a utility (Excel macro) working with unformatted text files. It uses the platform "EXCEL 97 / 2000 ". The main focus is "comparing two text files", "identifying duplicate records" and "filtering", always using only selected columns.

Publisher review for ASCII Key 1.3:

Review by: Ulrich Muehlenhoff
ASCII Key is a utility using unformatted text files (ASCII- or other character sets). It uses the platform "EXCEL(c) 97 / 2000 ". The main focus of the program is "comparing the contents of two text files", "identifying duplicate records" and "filtering".
These features always refer to the "key columns", which can be easily determined by using a special function before starting the program.
By allowing to process multiple files ASCII Key can be used also to combine single text or HTML files into one large file. More features:
Join: Copy selected columns from one file to another in case of identical keys.
Split: Split a file according to its key columns.
Statistics: Counting the occurrences of words in text files (giving the number for each different word).
All functions maybe extended by repetition (input = output, e.g. searching common keys in several files). For an easy start of the program you may save all parameters as well as the paths of all input and output files in a "variant". It is possible to store your variants in a separate Excel file so that when substituting the ASCII Key file (e.g. by a new version) all your saved settings are preserved.
There is no general restriction concerning the number of lines ASCII Key is able to process. This number only depends on the features of your computer, especially on the RAM size. All text elements of the program maybe shown in English or German.
Applications: A major area of application is in the office, especially if you extract data (text files) from a host system and you need a further processing of these extracts (e.g. compare it with other files, filter it).
Requirements:
Pentium 133, Excel 97 / 2000

Operating system:
Win95,Win98,WinME,WinNT 4.x,Windows2000

Release notes:
Major Update

Whats new in version 1.3:
For all functions of the program it is now possible to process many files (up to 65 536) during one run.

ASCII Key download tags:

utility compare text file key fields filter combine excel macro duplicate split join

Copyright information: