Table Find Examples
The criteria in this example will find cells whose
AvgDiskBytes/Write value is at or above 5,000 and that were written on first day of the
month (
Return a subset of the string in the formula is set to start at the fourth
character in the time stamp, so it will find 06/01/09 and 10/01/09 but not
06/13/09).

Column | Type | |
---|---|---|
AvgDiskBytes/Write | >= 5,000 | |
Timestamp | ![]() |
The criteria in this example were written for the table in the EIB Change Log
workspace to find entries that have been updated and that have "Disk" somewhere in the
name. (
Return a subset of the string and
Scan for string within a string are described in STR and
SCAN.)


Column | Type | |
---|---|---|
Table Name | == IDDefSituation | |
Operation | == Update | |
Object Name | ![]() |
Most special characters are processed correctly in the find function. If you
attempt to find text that includes a special character and it is not found, but you know
it exists in your environment, precede the character with the \ backslash escape
character. In this example, the user is searching through Temporary Storage Queues for a
Queue ID of #ETC. This is how it is entered in the Value cell:
Column | Type | |
---|---|---|
QueueID | == '\#ETC' | |
CICS RegionName |