Note: Both function FILTER and function FILTERW are illustrated to clarify the differences between them.
Table 169 FILTERW Function Examples
Function |
Returns value: |
---|---|
FILTER('TOTALS','T') |
OALS |
FILTERW('TOTALS','T') |
OTALS |
FILTER('TOTALS','TO') |
ALS |
FILTERW('TOTALS','TO') |
TALS |
FILTER('MULTIPLICATION','TI') |
MULPLCAON |
FILTERW('MULTIPLICATION','TI',2) |
MULTIPLICAON |
FILTERW('1-800-555-1212','-',2,3) |
1-8005551212 |
FILTERW('05/18/2000, 05/22/2000, 05/22/2000','20',2,4) |
05/18/00, 05/22/00, 05/22/00 |
Parent Topic |