Came across the VB Split fucntion which I had never used before today, fom help: (anoted)
Description
Returns a zero-based, one-dimensional array containing a specified number of substrings.
Syntax
Split(expression[, delimiter[, limit[, compare]]])
Expression, Required. ‘’the string
Delimiter, Optional. ‘’String character used to identify substring limits. If omitted, the space character (” “) is assumed to be the delimiter.
Limit, Optional. ‘’Number of substrings to be returned; –1 indicates that all substrings are returned.
Compare, Optional. ‘’Numeric value indicating the kind of comparison to use when evaluating substrings. See Settings section for values.
might be handy to have this around!