Int - GetAsNumber

[enquirerfm]

I have a field which I am attempting to parse to extract various data to post into other fields. In the first part it contains a 4 digit number which I wish to extract whilst numbers are present in the field later on...there must be a way of extracting the entire number as an integer and then only using the 4 digits on the left? Thx.

OK resolved this by using Left(GetAsNumber(DB::Fieldname);4)

Simple!

Edited October 14, 2010 by Guest

[comment]

Try =

Left ( Filter ( YourField ; "0123456789" ) ; 4 )

[TheTominator]

If you are sure that it is a 4 digit number then

Left(Filter(myDataField;“0123456789”); 4)

If it might be 1 or more digits then

LeftWords(Filter(myDataField;“0123456789 ,”); 1)

might be a better choice.