Page Comparison

...

Move the cursor down to the wrap option by pressing   until 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:

  options page

Finally press thethe 

Highlight
lightgrey class key lightgrey
ESC

 key to return to the document.

...

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 the 

Highlight
lightgrey class key lightgrey
MENU

  key until the LAYOUT menu is displayed. The Width command may already be highlighted as it is the first item on the menu; otherwise use the cursor keys to highlight it. Then presspress 

Highlight
lightgrey class key lightgrey
ENTER

 to select it. In reply to the prompt

New width

type

24

and presspress 

Highlight
lightgrey class key lightgrey
ENTER

 to carry out the change. (You can ignore the other prompt - Specify column.)

...

Now move the cursor into column B by pressing thethe 

Highlight
lightgrey class key lightgrey
TAB

 key, and repeat the procedure to set the width of column B to 24 also. You can, if you wish, select the Width command directly without going through the LAYOUT menu, by typing W.

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

Highlight
lightgrey class key lightgrey
TAB

key to get from column C to column D, the document moves to the left on the screen so that columns D and E come into view without the cursor position changing.

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

Highlight
lightgrey class key lightgrey
TAB

.

Type the following headings, pressing the TAB the 

Highlight
lightgrey class key lightgrey
TAB

key between each heading to move the cursor to the beginning of the next column.

Name     

Highlight
lightgrey class key lightgrey
TAB

 
Address  

Highlight
lightgrey class key lightgrey
TAB

Town      

Highlight
lightgrey class key lightgrey
TAB

County    

Highlight
lightgrey class key lightgrey
TAB

 
PostcodePostcode 

Highlight
lightgrey class key lightgrey
TAB

Info

Notice that when you type the word Town and press thethe 

Highlight
lightgrey class key lightgrey
TAB

 keykey, the document scrolls to the left so that the column headed 'D' comes clearly into view:

  Address Town screen

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  

Highlight
lightgrey class key lightgrey
TAB

. Press thethe 

Highlight
lightgrey class key lightgrey
ENTER

 key to move the cursor to row 2.

You can now type the first name into slot A2.

Bell , A

Press thethe 

Highlight
lightgrey class key lightgrey
TAB

 key when you have finished typing the name to move the cursor across to the address column, column B. Type in the address, remembering to press the TAB the 

Highlight
lightgrey class key lightgrey
TAB

key between each item:

Bell , A      

Highlight
lightgrey class key lightgrey
TAB

 
2 Ringway  

Highlight
lightgrey class key lightgrey
TAB

 
Tring Tring         

Highlight
lightgrey class key lightgrey
TAB

 
Herts  
Herts          

Highlight
lightgrey class key lightgrey
TAB

 
TE1 2LM    

Highlight
lightgrey class key lightgrey
TAB

 
24

  Name Address Town screen

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.

...

Select the Save command by pressing thethe 

Highlight
lightgrey class key lightgrey
MENU

key until the FILES menu is displayed. Press the  key to highlight Save. Then presspress 

Highlight
lightgrey class key lightgrey
ENTER

 to give the Save command.

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

Highlight
lightgrey class key lightgrey
ENTER

. A copy of the document will now be saved to the filing system.

...

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 and keys to move up and down the document and thethe 

Highlight
lightgrey class key lightgrey
TAB

 and and 

Highlight
lightgrey class key lightgrey
SHIFT

Highlight
lightgrey class key lightgrey

 commands to move across the document between columns to the left and right.

...

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

 Screen shot

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   key and the TAB command

Highlight
lightgrey class key lightgrey
TAB

 command. Then give the Mark Block command again. When you have completed the second Mark Block command, the entire table of names and addresses will be selected and shown highlighted on the screen. 

 

Another screen sheet

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  

Highlight
lightgrey class key lightgrey
TAB

 .

To sort the block of slots, use the Sort command from the BLOCKS menu. Press the MENU

Highlight
lightgrey class key lightgrey
MENU

  key until the BLOCKS menu is displayed. Then press the  key until the Sort command is highlighted on the menu, and presspress 

Highlight
lightgrey class key lightgrey
ENTER

 to select the command.

...

Sort on column A

and press thethe 

Highlight
lightgrey class key lightgrey
ENTER

 key to perform the sort. (You can ignore the other prompts for the moment.)

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 Q:

  screen shot

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.

...

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  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 presspress 

Highlight
lightgrey class key lightgrey
ENTER

 to begin the search. The cursor will instantly find the name Hill, Max, allowing you to read off his address.

...

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.

...

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

Highlight
lightgrey class key lightgrey
MENU

 key until the PRINT menu is displayed. Select Print using the cursor keys, and then presspress 

Highlight
lightgrey class key lightgrey
ENTER

  to give the command.

...

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 thethe 

Highlight
lightgrey class key lightgrey
ENTER

 key to start printing. Once this is finished, give the Print command again, this time specifying the option as

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.

...

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

Highlight
lightgrey class key lightgrey
ENTER

  to give the Print command. Then move the cursor to the option

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.