Thanks for the help. The only problem is that the "right("00"+string,2) "
doesnt work. Any ideas? Thanks,
> use the split() function to convert your string to an array, then affect
> each member of the array to your variables.
> resplit your date with / as a delimitor.
> then use right("00"+string,2) to get the leading zero
> > Hello,
> > I was wondering how I could split this string into multiple variables. I
> > want to split it in two ways:
> > 1. At each comma
> > 2. Further split the date into three variables
> > Here is the string: DARHS,0102,1/2/2002
> > I want to split it like this:
> > strCode = DARHS (this is always five letters)
> > strID = 0102 (this can be any amount of numbers)
> > strYear = 2002
> > strMonth = 1
> > strDate = 2
> > Also, is it possible to make the month and date two digits (ex: month =
> > date = 02) instead of just one?
> > I appreciate the help.
> > Chris