If you are getting a string like that, then unless you know what text will be coming and in what order I don't think there is a way to split it programmatically. Possibly build a dictionary and compare bits of the string against the dictionary entries.
If you know what will be coming in the string you can use the VBS Left() and Right() functions to grab parts of the string and put them into other variables, but you will need to know the length of each string and the order that is appears in.
Best bet would be to have the DB query that returns the string throw some delimiters. Pass the work upstream!
If you know what will be coming in the string you can use the VBS Left() and Right() functions to grab parts of the string and put them into other variables, but you will need to know the length of each string and the order that is appears in.
Best bet would be to have the DB query that returns the string throw some delimiters. Pass the work upstream!
