FIND

You use this primary command to search for specific data.
Read syntax diagramSkip visual syntax diagram
Syntax

>>-+-FIND-+--string--------------------------------------------><
   +-F----+           
   '-⁄----'           

Parameters
string
Search string. Can be:
  • A character string not starting or ending with a quotation mark and not containing any embedded blanks or commas. The case of the string is ignored. Uppercase and lowercase representations of the same character match. For example, Mixed matches MIXED.
  • A character string enclosed in quotation marks. The string can contain blanks and commas. The case of the string is ignored. For example, 'Exact string' matches 'exact string'.
  • C followed by a character string enclosed in quotation marks (C'Frog'), or a character string enclosed in quotation marks followed by C ('Frog'C). The string can contain blanks and commas. The string must match exactly (including case). For example, C'Exact string' does not match C'exact string'.
  • X followed by a hexadecimal string enclosed in quotation marks (X'C1C2'), or a hexadecimal string enclosed in quotation marks followed by X ('C1C2'X).

If the string is found, it is displayed at the top position. The Col field indicates the position in the record. To find the next occurrence of the same string, press the RFind function key (F5) or enter the FIND command with no argument. A message is displayed if the string cannot be found. (See Primary commands for more information about browse commands.)