Finder

The Finder view lets you scan every script in your database. You can combine these options:

Button	Option	Effect
Aa	Case sensitive	When checked, the search becomes case‑sensitive—“A” and “a” are treated as different characters.
\b	Whole word	Limits results to occurrences not attached to other letters or digits. Words separated by spaces, punctuation, etc. are matched.
. *	Regular expression	Interprets your query as a RegExp, giving you the full power of patterns (quantifiers, classes, anchors…). The Case sensitive and Whole word options can still be combined.

Need a refresher on RegExp syntax? A concise tutorial is available at https://regexone.com.

Regular expression example :

The following RegExp finds every select whose where clause filters on ID:

\bselect\b[^;]*(?<!\.)\bid\b

This helps you quickly spot places where you can replace first(select myTable where ID = searchId) with the faster alternative: record(myTable, searchId).

How it works step by step :

RegExp Pattern	Explanation
\bselect\b	Matches the whole word select (prevents matching words like “selected”).
[^;]*	Matches zero or more characters except ;, ensuring no semicolon appears between select and id.
(?<!\.)	A negative lookbehind that asserts there is no . immediately before id.
\bid\b	Matches the whole word id (prevents matching substrings like “userid” or “ident”).