Hopefully someone can help.

 

Is there a formula to search a string for a certain letter?

 

I am abit of a novice at the moment.

 

basically,

 

We have invoice numbers like: I3215481

 

our credit note numbers are: CR456481 or CDR168156

 

 

ALL credit notes contain the letter "R" in either the 2nd or 3rd position in the string.

 

what kind of formula / function would I need for this?

 

I have tried:

 

if {trnstk.invdate} in ["R"] then true

 

but it dont work.

 

 

all help greatly appreciated.

 

 

 

thanks

 

I did solve it myself just, using a longer method.

1st Formula:     instr({TRNSTK.INVNUM},"R",1)

thankyou for your help :)