How to find substring

chrscote · June 13th, 2003, 07:40 PM

I am trying to take the separate parts of a decimal number. I have used the InStr method to determine if the decimal exists or not (ex. I could have just 5 instead of 5.2) Now I want to place the 5 in a FullNum variable and the 2 in the FracNum variable. I tried using the Mid function, but I keep getting a "Invalid procedure call or argument 'Mid'" error message. I always thought that VB used the Mid function as opposed to substr or something like that. Could someone please help me?

Chris Cote

NotNowJohn · June 14th, 2003, 03:13 AM

Try this:

Code:

arr_dec=Split(dec_number,".")
FullNum=arr_dec(0)
FracNum=arr_dec(1)

Regs,
NotNowJohn

...but the Soon is eclipsed by the Moon