[RESOLVED] truncate integer in string

[hondaboy24]

hello, is it possible to truncate or get the value of a number in a string? i have a combobox that displays varchar values from the database for example MNG-5.

i want to get the number 5 and maybe put it in a label or a textbox, is it possible? thanks.

[jcis]

The String will always follow that Chars-Numbers Pattern?

[hondaboy24]

Yes it does.

[leinad31]

Will that always be the format? Will there always be a dash preceding the number? Will the number be always at the rightmost portion of string?

[leinad31]

Debug.Print CLng(Split(yourString, "-")(1))

[hondaboy24]

Debug.Print? can you use that in vb6? I'm sorry i must have forgotten that i am using vb6 hehe

[leinad31]

Just a way to show the output. Debug.Print outputs to the IDE's immediate window. You can use MsgBox if you prefer.

[jcis]

In this case you won't need CLng() since you want the result to be String Format to add it to a TextBox or Label.

[hondaboy24]

Oh. but is it possible to get the value of the integer and store it somewhere? like maybe in a label or a textbox?

[leinad31]

Yes, result is a string. Simply assign it like you would any other string.

[hondaboy24]

thanks.