trim string

hi there,

i would like to ask about trim/mid.
my problem is like this.

let's say i have string like these:

var1 = F41
var1 = DG48
var1 = VKU52

what i wat to do is i just want to take numbers from that string where

the output will become like these:
var1 = 41
var1 = 48
var1 = 52

normally i use mid before this, but if i use mid, i have to make sure

the starting char and it's lenght like this:
mid(var1, 2,2)

but i cannot do like this because the number sometimes at the 2nd

character, sometimes at the 3rd character and etc.

how to do the coding?
thank you very much and i really appreciate for any help given.

well, if the number is only going to be two chars long, you could use right


hope this helps

Actually, yeah. I've wondered before how to separate alphabetical characters from numbers. Is there a set method?

I had the same issue a few weeks back and Memnoch gave me the perfect function to use.

Go here and check it out.

Hope this helps you.

hello there..

thank you very much to all repliers..

to mehere i'll go to that suggested link and try the solution now.

thanks.