Set Functions

Prev Next

Introduction

This section describes various functions used to process or check sets.
Additional powerful functions using sets extensively are series functions, matrix functions, statistics functions and conditional combination functions.


Procedures and Functions Provided:


length [set function]:
    length

find [set function]:
    find
    find ignore blanks
    find ignore both
    find ignore case

left [set function]:
    left
    left include
    left last match
    left last match include

right [set function]:
    right
    right include
    right last match
    right last match include

middle [set function]:
    middle
    middle include
    middle until
    middle until include

outside [set function]:
    outside
    outside exclude
    outside until
    outside until exclude

trim [set function]:
    trim

Count elements in sets:
    count elements
    count elements ignore blanks
    count elements ignore both
    count elements ignore case

Subsets from sets:
    subset
    subset ignore blanks
    subset ignore both
    subset ignore case
    subset recursive
    subset recursive ignore blanks
    subset recursive ignore both
    subset recursive ignore case
    filter
    filter 1
    filter n
    filter start
    filter start include
    filter start n
    filter start n include
    filter stop
    filter stop include