Extracting information from a string 3

[marckssg]

Hi, I know I've done this in the past, but can't for the life of me remember how!

I have a field which contains information such as
"1234 ABCD"
if I want to split this field so that the "1234" appears alone how would I do it? The "1234" can very in length, but there is never a space in the numbers but always a space between the numbers and the text, the text also varys in length.

Cheers

Marc

 

[FoxG]

Hi,
this formula should do the trick!!

numbervar n := tonumber(left({field},instr({field}," &quot-1))


Geoff

 

[MalcolmW]

Val({field}) should also do the trick. Malcolm Wynden
I'm for sale at

http://wynden.net

malcolm@wynden.net

 

[FoxG]

Cheers Malc, not spotted that one before, a lot shorter

... as long as the second field does not have a number at the beginning!

Geoff