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