You can use the EXCLUDE command to specify a string that is up
to 100 characters long. However, when you are dealing with long strings,
you might find that you cannot fit the whole EXCLUDE command (including
other parameters) on the Command line. To overcome this problem, do
one of the following to display an Extended Command Entry pop-up panel
(see Figure 1):
Enter XX (for Exclude Extended)
Enter the EXCLUDE primary command (or one of its abbreviations,
such as X) with no parameters.
The Extended Command Entry pop-up panel contains five lines (each
50 characters long) that you use to enter all the EXCLUDE command
parameters (but not the actual keyword EXCLUDE or any of its abbreviations).
File Manager treats the five lines on the pop-up panel as contiguous,
allowing you to specify a long search string and any other parameters,
using up to 250 characters in total.
Note: You can continue a string (or any other parameter) from the last position
on one line of the pop-up panel to the first position of the next line.
However, this does not mean that you need to completely fill a line before
using the next line. For example, you can specify the search string on the
first of the five lines and the other parameters on the next line.
If you are not specifying a quoted string and you do not use all of a line,
File Manager treats the unused part of the line as
a single space. When you specify a string with quotation marks, any trailing blanks
and any leading blanks in the next line are retained.
Figure 1 shows the Extended
Command Entry pop-up panel for the EXCLUDE command. This example searches
for all occurrences of the string “dichlorodiphenyltrichloroethane”
in field #3.
Figure 1. Extended Command Entry pop-up panel for the EXCLUDE command
Process Options Help
───────────────────────────────────────────────────────────────────────────────
Edit USERID.FMDATA(NEWDATA1) Rec 0 of 40
Format TABL
┌───────────────────── Extended Command Entry ──────────────────────┐
│ │
│ Complete typing the EXCLUDE command and press Enter. │
│ │ ->
0 │ EXCLUDE ===> dichlorodiphenyltrichloroethane │
0 │ ===> all #3 │
0 │ ===> │
0 │ ===> │
0 │ ===> │
0 │ │
0 │ │
0 │ F1=Help F2=Split F3=Exit F9=Swap F12=Cancel │
0 └───────────────────────────────────────────────────────────────────┘
000009 000140 ammonium hydroxide solution
000010 000150 dichlorodiphenyltrichloroethane
000011 **** End of data ****
Command ===> fx Scroll 0001
F1=Help F2=Zoom F3=Exit F4=CRetriev F5=RFind F6=RChange
F7=Up F8=Down F9=Swap F10=Left F11=Right F12=Cancel