findnth
NTH
,
SECOND

The findnth statement finds the nth (2nd, 3rd, 4th, etc.) record that matches a true-false test.


Parameters

This statement has two parameters:

nth – Occurence you want to fine (1, 2, 3, 4, etc.)

second – Formula for true-false test


Description

This statement finds the nth (2nd, 3rd, 4th, etc.) record that matches a true-false test. This example finds the fourth record in the database that contains “surf” in any field.

findnth 4,exportline() contains "surf"

See Also


History

VersionStatusNotes
10.0No ChangeCarried over from Panorama 6.0.