Dear Mat, Tim, Tom and all, Oops! Sorry you are right. It was a bit late when I sent that answer and I wasn't thinking straight. Although Val() will strip of trailing text leaving just the number that was at the front, it will only work when the number is at the front! I'll think a bit harder next time! Regards Bob In message <[EMAIL PROTECTED]>, Mats Elfström <[EMAIL PROTECTED]> writes >"Bob Young - www.bydesignwales.demon.co.uk" wrote: >> >> Dear Tim and Tom >> >> Only snag with this approach is that "F1 Racer" and other strings with >> numbers in will comme back too. >> >> You could try where val(recString) > 0 as an alternative. > >Hi Bob! > >I believe that Val() only evaluates leading digits, and stops parsing >the string on the first non-digit character. >To use Val() you'd have to write code to parse the string first from pos >1, then from pos 2 and so on until a number is found. >And you would still lose the strings with more than one number. > >Regards, Mats.E -- Bob Young - www.bydesignwales.demon.co.uk ---------------------------------------------------------------------- To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put "unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
Re: MI - selecting number within text
Bob Young - www.bydesignwales.demon.co.uk Mon, 15 Nov 1999 03:00:59 -0800
- MI - selecting number within tex... Tom Manson
- Re: MI - selecting number w... Chris Martin
- RE: MI - selecting number w... Timothy Chinchen Cen-IT
- Re: MI - selecting numb... Bob Young - www.bydesignwales.demon.co.uk
- Re: MI - selecting ... Mats Elfström
- Re: MI - select... Francois Molle
- Bob Young - www.bydesignwales.demon.co.uk