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 greatly appreciated.
Thanks,
Jim

 

[Naith]

Without seeing sample data, I'd guess that you'd be able to use the output of

Val(Mid({Your.Field},InStr({Your.Field},'/')+1))

in your calculations.

All the best,

Naith

 

[DrHabi]

Thanks works great!