Instr formula or something similiar 1

[DrHabi]

Hi,
I am in need of of formula that would allow me to search a field for a mark such as "/" then take the next character( which will be a number). I have been playing around with using instr and have not been to successful but maybe I need to do an array search. What the main goal is that I will have a field called {package.id} and within this field will be a "/" then a number. Based on this number I will do certain calculation. The length will not be set but random. Any suggestion would be great ly appreicated.
Thanks,
Jim

 

[bdreed35]

You should be able to use Instr() to accomplish this.

If Instr({table.field},"/")>0 then
    Mid({table.field},(Instr({table.field},"/")+1),1);
//Else
   //whatever condition you need if the / is not present

~Brian

 

[DrHabi]

Thanks but I somehow clicked twice for the same post the formula that I used is
Val(Mid({packages.id},InStr({packages.id},'/')+1))

It works great