Find Page
\The Sandbox \PBL Peeper \Online Manual \Find Page
PBLs Page
Browse Page
Lists Page
Find Page
Reports Page
Trace Page
Exports Page
Process Page
Compare Page
Print Options
PSR Viewer
RTF Viewer
SQL Format
Script Formatter
SQL Parser
Command Line
Applied PP
Known Issues
Tip of the Day

pblpeepericons-findtabpage.jpg Find Page


The purpose of this page is to find occurrences of one or more strings. The results, with requested context, are displayed in a rich text window, or in a DataWindow list window. The page is made up of two panels, top and bottom. The purpose of the top panel is to enter one or more items to search for, as well as parameters specific to each individual item. The purpose of the bottom panel is to enter overall parameters for the search.

Available menu items

pblpeepericons-objectfilter.jpg  Object Filter

Allows a definition of a subset of objects within the application to be searched. This definition is with a DataWindow filter expression. Fields available for the filter are the same as initially available from the Object List. When an object filter is active, the menu item will be checked and the toolbar button will be depressed.

Top Panel



The string to search for.

Match type

Determines how the Containing field is to be used to identify string matches in scripts and portions.

Character by Character

Matches using the exact contents of the Containing field.

Match() Expression

Compares the expression in the Containing field against physical lines in the portion, using the Powerscript Match() function. Because of the nature of this option, it will ignore Whole Word Only, Ignore Comments and Ignore Quotes options. Match expression characters for the start and end of a string (^ and $) will be matched to the start and/or end of physical lines in the script.

Whole Word Only

If checked, matches cannot be substring of another word or identifier. This is defined as the character before and the character after the matched string are not characters that are valid characters for a PowerBuilder identifier or variable.

Case Insensitive

If checked, matches the Containing field by matching as specified by the Match Type, but ignoring case.

Available menu items

pblpeepericons-insert.jpg  Add Row

Adds a row to the bottom of the list of search criteria. (Note: Order of search items is inconsequential.)

Insert Row

Inserts a row before the currently selected row of search criteria.

pblpeepericons-delete.jpg  Delete Row

Deletes the currently selected row.

Clear Rows

Removes all rows.

Bottom Panel


Portion Types

Identifies which set of portions are to be searched. This is used to restrict the search only to portions that are desired, such as scripts only.


Functions and events only.

Scripts & Variables

Functions, events, instance variable declarations, shared variable declarations, global variable declarations.

DW Objects

DataWindow objects only.


All objects, all portion types.

Include Comments

Include in output matches that are found in comments. Excluding matches contained in comments slows the search, as the context of each match has to be evaluated with respect to comments.

Include Quotes

Include in output matches that are found in quotes. Excluding matches contained in quotes slows the search, as the context of each match has to be evaluated with respect to quotes.

Output Type

Identifies the desired output when a match is found.

Object Name

The name of the object, identified with its PBL name, is output. This is the fastest output type, as the object does not have to be indexed when a match is found. If this option is selected, the Portion Types field is ignored and only the existence of the string within the object is verified.

Script Name

The PBL, object and script or portion names are output.

Entire Script

The PBL, object, script name and contents of the scripts or portions are output. When DataWindow Output is checked, this option will default to Context Lines, since DataWindows don’t display multi-page scripts well.

Context Lines

The PBL, object, script name and the context lines around the matches are output. When this output type is selected, a field for number of context lines becomes available. Entering zero in this field will output the code line that the match is found in, including portions of code lines extended with the ampersand (This does not work with matches found in SQL statements). Entering a non-zero number will output the physical line containing the match, plus the specified number of physical lines before and after the matching line. This is the slowest output type, as the context has to be determined, and multiple contexts have to be merged if overlapping.

Page Breaks

Determines where extra page breaks are inserted into the output.


No extra page breaks are inserted. Only page breaks that the rich text edit field puts in because of the volume of text appear.

Between Objects

Page breaks are inserted whenever output for a new object starts.

Between Scripts

Page breaks are inserted whenever output for a new script starts.

Bold Matches

When directing output to rich text, found elements that are using Character By Character will be bolded, if the text is shown. This may slow output processing somewhat, but will make matches easier to find in the output, especially when showing Entire Script or a number of Context Lines.

DataWindow Output

This will direct the output of the Find to a DataWindow, with regular Sort, Filter and Find functionality. In addition, you can link back to the Browse page through the Browse toolbar button or menu item, and can generate Object Filters based on the list. Options specific to rich text, like Bold Matches or Page Breaks are ignored.

Count Occurrences

Checking this will search for all instances of the search targets, and provide an item by item count summary. The level of detail of the counts will depend on the Output Type. When DataWindow Output is checked, and Output Type is Context Lines, this option does not produce any results, although the DataWindow Output option provides some of its own counting natively.

Suppress Zeroes

When the count of a search target is zero, the count is not reported when Count Occurrences is checked.

PBL Peeper PB Help PB History
& Future About Us Feedback Site Map