Return field data starting at number 1

[mgallot]

I need to return data from an address field (address1) starting where a number exists.
Example:
Sunny Hill Gardens 1601 Sunshine Lane - data in field
1601 Sunshine Lane - data that needs to be returned

The numbers are always in different positions in the field.
Thanks for your help.

 

[briangriffin]

whileprintingrecords;
numbervar i := 1;

while i <= len({AddressField}) and not(isnumeric({AddressField})) Do

(if isnumeric({AddressField}) then i
else i := i + 1);

mid({AddressField},i,len({AddressField}) -i + 1);

 

[mgallot]

That worked like a charm!

You are a superstar.