Example
1:
You have a list of sales that contains - besides from the
item numbers - also headers, subtotals,
blank lines and so on. However, you are only interested in the item numbers.
Furthermore, you have a file that also contains item numbers, e.g. a catalogue of goods for sale in terms of an Excel
file. Let's assume you would like to know which items are not found in
the list.
Strategy:
You may
write a complete line of your catalogue (e.g. incl. the item name) to the
output file or only the item number e.g. for later use in a further run of the program.
Example
2:
You
download a catalogue of sales from the
internet in terms of a text file containing an item number, name and price. One
month later you download the same catalogue again.
Now you
whish to know:
Which items
are new, which items were deleted, for which items there was a change
in price?
Strategy:
1. Start ASCII Key, old version
of the catalogue = "input file 1", new version of the
catalogue =
"input file 2"
2. Determine the column ranges
that are to be compared: column range 1: item number, column range 2: price.
Mark the column range "price" in both file as "data
columns"
3. Start the program, option:
"Compare", all output files
activated
4. Result: you find the new items in output file
2, deleted items in output file 1, items whose prices have changed
in output file 4
5. You save your settings in a
"variant" (only possible with
the registered version)
The
next time you download the catalogue you only have to use the settings stored
in the variant!