NODES – Return the number of nodes in a string
This function returns the number of nodes within a string, using a specified delimiter.
NODE(<string>,<delimiter>)
Where:
<string>
- String from which to extract the data.
<delimiter>
- String that delimits each node.
Unlike the functions
WORD
and WORDX
, which
ignore leading and double spaces, the NODES
function counts every
delimiter. For example, the following command returns 5:
NODES(“FIVE!FOUR!THREE!TWO!ONE”,”!”,2)
The following command returns 6:
NODES(“.A.B..C.D”,”.”,2)