Handling long strings in EXCLUDE

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). Z Data Tools 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, Z Data Tools 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    

Related topics