Please help me with my string formula 1

[Tupence]

Hi,

I'm trying to find a way of counting how many payments count{charges.ncharge} and how much sum{charges.ncharge}have been made "by us" and "by client", the only place in my database where this info is found is in an automatically generated comment string field {comment_.ccomment}. I am not familiar with string formalas and would be greatful of some help. The field {comment_.ccomment}will contain the words "received by us" and "received by client" e.g cheque received by client.

thanks

 

[kskid]

As far as searching a string, create the following formula

//@Received_By
if instr(uppercase({comment_.comment}),"RECEIVED BY US")> 0 then "US"
else if instr(uppercase({comment_.comment}),"RECEIVED BY CLIENT") > 0
then "CLIENT"

-lw

 

[Tupence]

Thanks Kid, really helped me out.