Need to convert string!

[hinchdog]

I need to convert the following string using VBScript --

3/13/01 5:24:11 PM to 01,3,13,5,24,11

Is there a regex guru who can help me! Thx.

-Hinchdog

 

[link9]

dim thisString, thatString
thisString = "3/13/01 5:24:11 PM"
thatString = replace(thisString, "/", ",")
thisString = replace(thatString, ":", ",")
thatString = left(thisString, 15)

That should do it. If there is the possibility of different length strings, then you would need to use the len function to get the length of the almost final string (the one that still has the 'PM' on it), and then just subtract 3 from the return value to know what value to use with the left function.

good luck!
Paul Prewett

 

[hinchdog]

elegant! thanks Paul.

Hinchdog (aka Frank)