Parse string

[JonathonC]

I have the string F,50 and a want to split the string into two, I want to get the part before the comma (F in this case) and the part after it (50 in this case) and then save each of these parts to two separate strings. How would I do this?

Thanks,
Jonathon.
Computer problems? Have you checked the loose nut in front of the keyboard yet?

 

[JohnYingling]

Dim aryStr() As String
aryStr = Split("F,50",",&quot
if UBound(aryStr) < 1 then Redim Preserve aryStr(1) ' no comma
strF = aryStr(0)
str50 = aryStr(1)

http://www.VBResizer.com

Generate Forms/Controls Resizing/Tabbing Class

http://www.VBCompare.com

Compare Code (Text)

http://www.VBSortGen.com

Generate Sort Class in VB or VBScript

 

[JonathonC]

Thanks John thats exactly what I was looking for.

Jonathon.
Computer problems? Have you checked the loose nut in front of the keyboard yet?