Problem with val function

[nivini]

I have this code

if instr(1, text1.text, "TEMP") then
valTEXT=val(text1.text)
end if

text1.text contain TEMP8003
not as expected, the valTEXT variable gets 0 instead of 8003
can you solve this mistery to me?
nivini

 

[ADoozer]

From MSDN

The Val function stops reading the string at the first character it can't recognize as part of a number.

so since T isnt a number it returns 0.

if the format is to always be TEMP<Number> then you can use

if instr(1, text1.text, "TEMP") then
valTEXT=val(mid(text1.text,5)
end if

If somethings hard to do, its not worth doing - Homer Simpson

 

[nivini]

ADoozer
Many thanks
nivini

 

[strongm]

From MSDN? Heck, it is documented in VB's online help files, often a good place to look for help on VB ...

F1 is your friend

 

[tsuji]

[1] Recall to a recent discussion.

http://tek-tips.com/viewthread.cfm?qid=1198556

[2] Slightly generalize prefix+num+... structure as posted.
[tt]
if instr(1, text1.text, "<prefix>") then
valTEXT=val(mid(text1.text,instr(1,text1.text,"<prefix>")+len("<prefix>")))
end if
[/tt]