Regularization of delimiter in split command
Is it possible to regularize the delimiter in Split command?.
The code is
Temp = Split(tmp, "NA ")
In the above code the delimiter is just "NA"
I want the delimiter as NA followed by 2 numerical character.
Re: Regularization of delimiter in split command
A simple way is to do a split on NA then remove the next 2 chars using Len to ID the length of the string then use Right(myString,Len-2) kind of statement.