I've got a field in my db that as too many values in it, and I need to split it up. The character inserted that indicates the split is "&".
The first set of numbers is no set length.
The second set should always be the same
The third set is 3 characters
The final set is a name.
I want to split them like this
Num = 1st set
date = 2nd set
secret = 3rd set
Name = Last set
How can I do this with VBscript???