Page Comparison

.key { border-right: #000000 1px solid; padding-right: 1px; border-top: #000000 1px solid; padding-left: 1px; font-size: 12px; font-weight: normal; border-left: #000000 1px solid; border-bottom: #000000 1px solid; }

This example shows how you can enter any type of information such as a library catalogue, a book index or bibliography, or a name and address list into the Cambridge Z88 using PipeDream.

...

Select the Options Page by typing Image RemovedImage AddedO. You will see a display showing the different options you can select for your document, and information about the document.

Move the cursor down to the wrap option by pressing Image Removed Image Addeduntil the cursor is opposite the word Wrap. Then type N to change the option value from Y (Yes) to N (No) to stop wrapping altogether:

Image Removed 

Finally press the ESC wrapping altogether:

Image Added

Finally press the 

...

When you start a new sheet in PipeDream you are given six columns, each 12 characters wide. Although you can enter lines of text much wider than this in each column, it will make working with the name and address information simpler if, at this point, you make each of the columns in the document wider. You do this with the Width command in the LAYOUT menu.

Press the MENU key until the 

New width

type

24

and press ENTER prompt

New width

type

24

and press 

The width of the column containing the cursor, column A, will increase to 24 characters.

Now move the cursor into column B by pressing the TAB the 

Image Removed

Image Added

Continue until you have set each of the columns A to F to a width of 24 characters. Notice that when you press the TAB the 

Then move the cursor back to the left-hand side of column A by typing Image RemovedTABtyping Image Added

Type the following headings, pressing the TAB the 

Name TAB
AddressTAB
Town TAB
County TAB
Postcode TAB
Info

of the next column.

Notice that when you type the word Town and press the TAB word Town and press the 

Image Removed Image Added

So, although you can only see three of the six columns in your document at any one time, it is a simple matter to move about and find the information you want.

...

Move the cursor back to the left-hand side of column A by typing Image RemovedTAB. Press the ENTER typing Image Added

You can now type the first name into slot A2.

Bell , A

Press the TAB the 

Bell , A TAB
2 Ringway TAB
TringTAB
HertsTAB
TE1 2LM TAB
24

Image Removed :

Image Added

Enter the other names and addresses given below on lines 3, 4, 5, and 6 of your document in exactly the same way. Of course, if you prefer, you can compile your own list. If part of an address is too long to fit within one column, just keep typing; although you will not be able to see all the information in that column, it will be retained and you will be able to refer to it later.

...

Complete the table as follows:

Name        Address         Town        County   Postcode  Info
Bell, A     2 Ringway   

...

    Tring       Herts    TE1 2LM   24
Long, C     9 Knott Close   Farnham     Surrey   WAY 2G0   27
Rover, A    4 Chase Mews    Kenilworth  Warw.    K9 WUF    12
Bird, J     27 Wood Lane    Bath        Avon     CB1 L23   14
Hill, Max  

...

 10 Upper Street Steep       Hants    UP 21T    43

Saving the document

Since by now you may have spent some time entering information into your document, it is a good idea to save a copy to the Cambridge Z88 filing system in case you accidentally lose the information during the next experiments. You save a copy of the document by using the same procedure as the one used for the party invitation.

Select the Save command by pressing the MENU key the 

Image Removed

Image Added

Type addresses as the name of file to save, ignoring the other options since you want to save the whole document, and press ENTERpress 

Sorting the information

Now that you have entered a table of names and addresses, it would be useful to have them sorted into alphabetical order so that you can look up a particular name more easily.

First you need to specify which part of your document you want to sort. Move the cursor to slot A2, the top left-hand comer of the table of names and addresses, using the Image Removed Image Addedand Image Removed Image Addedkeys to move up and down the document and the TAB and SHIFT TAB the document and the 

Mark slot A2 by giving the Mark Block command from the BLOCKS menu, or by typing Image Removed Image AddedZ.

When you give the command, slot A2 will be highlighted on the screen to indicate that it has been marked:

Image RemovedImage Added

Now mark the bottom right-hand corner of the table of names and addresses. Move the cursor down to row 6 and across to column F with the Image Removed key and the TAB Image Added  key and the 

 Image Added

The highlighted table of slots is referred to as a 'block', and several commands are available which will operate on an entire block of slots that you have selected.

Move back to the left-hand side of the sheet with Image RemovedTAB .sheet with Image Added

Image Removed

Image Added

We wish to sort the names and addresses into alphabetical order of the names, which are in column A, so type A to the prompt

Sort

...

 on column A

and press the 

You will see that the names and addresses have been correctly sorted within the table. You can clear the marked block by giving the Clear Mark command from the BLOCKS menu, or by pressing Image RemovedImage AddedQ:

Image Removed Image Added

You could, of course, have sorted the information on a different heading by specifying another column, rather than column A, when you gave the Sort command. For example, you may like to experiment with sorting the same names and addresses on the Town column, or on the column containing the peoples' ages.

Finding information

You could have entered many more names and addresses than the few you have already stored without running out of space in the document.

You can see how much space is available in a document at any time by typing Image Removed Image AddedO to display the Options Page. The number of characters of space available is given after the heading Free on the right-hand side of the Options Page display. Press ESC Press 

In a large list of names and addresses, it would be very inconvenient to have to search around in the list for a particular name or address. Fortunately, there is a much faster way, using the automatic search facility built into PipeDream.

Select the Search command from the BLOCKS menu in the usual way: display the BLOCKS menu with the MENU the 

The Search command displays a number of options which allow you to specify exactly what you want to search for, and whether you want to restrict the search to a particular part of your table of information. For example, you might want to search for the address of someone whose surname you had forgotten, but whose Christian name you knew to be Max. You would then enter Max against the first option:

String to search for Max

Press Image Removed to Image Added to move to the next option which initially shows:

Search only range of columns    No

and press Y to alter the option value to Yes, and type A, to specify that you want to search only column A, which contains the names. The option will now read:

Search only range of columns    Yes A

Then press ENTER press 

Incidentally, if the name you chose to search for found someone else with the same name first, you could use the Next Match command on the BLOCKS Menu to move on and find the next item that contained the same name.

Help with searching

It is a peculiarity of the way we remember information that we can often only remember part of what we are trying to recall. For example, we may know that the person we are trying to find lives in a town called something like Caxton - or perhaps it was Croxton? Or then again, perhaps it was Foxton. The PipeDream Search command has two facilities which help in just this type of situation.

You can type the symbols ^# in the string you are looking for, to represent any combination of letters (including none). Thus, you simply have to specify

String to search for         ^#xton

to find any of the towns, Caxton, Croxton or Foxton, or any other town ending in 'xton'.

You can also specify the symbols ^? which will match any single letter or character in the string you are searching for. So, if you could only remember that the name of a road had three letters, you could search for

^?^?^? Road

and you would be sure to find it.

Printing information

To print out the information in your name and address list as an orderly table, select the Print option from the PRINT menu. Press the MENU the 

Since the total width of the table of names and addresses is 144 characters (six columns of 24 characters) it will probably be too wide to fit across the width of the paper on your printer; most printers will only print 80 characters. You will therefore need to print the table in two sections, by selecting a range of columns in each case.

The first time you give the Print command, alter the option

Print only range of Columns No

to Yes by typing Y, followed by A C so that the option reads

Print only range

...

 of columns Yes A C

Then press the 

Print only range of columns Yes D F

Alternatively, some printers will print up to 132 characters across; in this case you may be able to fit the whole table onto a single sheet of paper by first reducing the width of some of the columns using the Width command on the LAYOUT menu.

Anchor
Printing_selected_rows Printing_selected_rows

Printing selected rows

If you were going to use the name and address list for a business mail shot, you might want to compile a selective list containing only the names and addresses of people living in one particular area. The PipeDream Print command caters for this by allowing you to specify a test to be performed on each row of the document. Only those rows for which the test succeeds will be printed.

...

For example, to print out the names and addresses of all the people living in Hants or Surrey, give the Print command in the usual way by displaying the PRINT menu and then pressing ENTER pressing 

Select rows to print No

Change the option value to Yes, by typing Y, and type in the selection expression

D1="Hants" | Dl="Surrey"

The '|' symbol means 'OR', so the whole expression means: "If the item in slot D1 is Hants or the item in slot D1 is Surrey...". In row 2 the test will apply to D2, and so on.

The selection expression can be virtually as complicated as you need, and can include tests on several different columns. For example, for a mail shot of information on a new wonder hair tonic you might want to select all men over 30 on the name and address list. The expression might be

Dl="London" & G1="M" & F1>=30

where G1 was an extra column containing M or F to indicate the sex. The '&' symbol means 'AND' and can be used to link several tests together.