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)