How to exclude tickets with certain word in field.

[rico7937]

I am using Crystal Reports 10. I have a field called Problem Abstract which is a free form text field with a limit of 55 characters. I am trying to come up with a formula that would exclude tickets containing the word "Password" in the problem abstract field. Any ideas or suggestion would be greatly appreciated.

 

[synapsevampire]

Try:

If instr(uppercase({table.problemabstract}),"PASSWORD") > 0 then
"Password"
else
{table.problemabstract}

-k

 

[MCuthill]

Rico:

In your record selection you could add:

[blue]NOT[/blue]("Password" [blue]IN[/blue] {Table.ProblemAbstraction})

Hope this helps,

Mike
______________________________________________________________
"It Seems All My Problems Exist Between Keyboard and Chair"

 

[rico7937]

Thank you for all of your help! Both of these formulas work well ! Is there a way to enhance these formulas by adding other words to them ? They now want me to exclude up to 15 different other words in the formulas. Here are the words:

password, pswd, expedite, expedited, reset, disable, disabled, unlock, unlocked, expidited, experdited, SLA, SAP Implementation, PeopleSoft, or past due.

How do I go about this ?

 

[lbass]

Use a record selection formula like:

not(
ucase({table.problemabstract}) like "*PASSWORD*" or
ucase({table.problemabstract}) like "*PSWD*" or
ucase({table.problemabstract}) like "*EXPEDITE*" //ETC.
)

-LB