Split a string

davesmith202

Employee of Access World
Local time
Today, 12:13
Joined
Jul 20, 2001
Messages
522
I want a function that takes myString like this {dogs:dog food} and splits it into 2 variables:

var1=dog food
var2=dog

But, sometimes there might only be {dog food} in myString, in which case that gets stored var1.

Any ideas how I might achieve this? It has got to cater for both potential scenarios.

Thanks,

Dave
 

Users who are viewing this thread

Back
Top Bottom