S A M P L E   F O C E X E C S

Masks

To screen on a part of a data element, use "$" to block out the part you do not wish to consider. 
>
tfs
count empno by ccto
if ccto is h$$
end

NUMBER OF RECORDS  IN TABLE=     115     LINES=       12

PAGE       1

       EMPNO
CCTO   COUNT
----   -----
H10        3
H15        5
H20        4
H25        7
H35       55


>
tfs
count empno by bdate
if bdate ge 45$$$$
if recordlimit is 5
end

NUMBER OF RECORDS  IN TABLE=       5  LINES=     5

PAGE         1

              EMPNO
BDATE         COUNT
-----         -----
46/08/06          1
50/08/13          1
53/05/23          1
56/02/04          1
65/03/23          1
Back to Sample Focexecs