my field is as follows;
00000152633 STEELMATIC WIRE USA, IN
i am using this formula to try retrieve the numeric porition of this field
{USR_CR_BEN_ACT;1.BENE}[instrrev({USR_CR_BEN_ACT;1.BENE},' ')+1 to length({USR_CR_BEN_ACT;1.BENE})];
what i get is STEELMATIC WIRE USA, IN
what can i use to get 00000152633
thanks