@accfs Function |
![]() ![]() ![]() |
@accfs() (Accumulate from String) function is similar to the @accfa() function with a difference that the @accfs() function parses the delimited substrings in the given string and performs an accumulation for the each substring that satisfies the specified precondition and returns the accumulated value. Syntax: @accfs(string, substring-delimiter, [precondition], accumulate-by-expression[, delimiter]) string The string that contains the delimited substrings to process. substring-delimiter The character that delimits the substring in the given string. When parsing the substrings the quotes and the parenthesizes are considered to be the grouping symbols and the delimiter characters existing within them are ignored.
If no value is given as the delimiter then each character in the string accepted to be a substring.
precondition If this parameter is not left blank it is tested as a precondition for each substring parsed and if the result is true, only then the accumulation is performed. accumulate-by-expression For each parsed substring that satisfies the precondition, this expression will be evaluated and accumulated in the result. delimiter This optional parameter can be used when accumulating string data and it will be placed between accumulate-by-expression values. The delimiter is not placed for the first accumulation. '.' Symbol '.' character represents the parsed substring and it can be used as a symbol within precondition and accumulate-by-expression.
Examples:
|