Skip to Content
0
Former Member
May 20, 2010 at 12:51 PM

instrrev function

415 Views

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