Documentation for smfWord() function

Description

A utility function to extract nth word from a string using a delimiter.

Syntax

=smfWord(Haystack, Occurrence, [Delimiter], [Convert], [Reverse])

Parameters

Haystack	=	String to extract the word from.
Occurance	=	The nth word found surrounded by the delimiter.
Delimiter	=	Optional - Default is “ ”. String to delimit the Haystack into words. If a zero-length string is used; i.e., “”, Haystack will be returned.
Convert	=	Optional - Default is 0. If set to 1, function will attempt to convert the substring to a numeric value, for example convert “50K” to “50000”.
Reverse	=	Optional - Default is 0. If set to 1, function will retrieve the substring starting at the end of Haystack and work backwards.

Examples

To extract the 3^rd word from "apples - oranges - bananas - grapes", use: =smfWord("apples - oranges - bananas - grapes", 3, "-") ... giving “ bananas ” including the surrounding spaces.

To extract the 2^nd word from "apples - oranges - bananas - grapes", use: =smfWord("apples - oranges - bananas - grapes", 2, " - ") ... giving “oranges”; the delimiter includes spaces.

To extract the 3^rd word from "Accounts Receivables: 700K", use: =smfWord("Accounts Receivables: 700K", 3, , 1) ... giving “700000” using the Convert parameter.

To extract the last word from "apples - oranges - bananas - grapes", use: =smfWord("apples - oranges - bananas - grapes", 1, , , 1) ... giving “grapes”.

Usage notes

None at this time.