Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Technical Questions
Message Icon Topic: Filter text string containing certain text Post Reply Post New Topic
Author Message
eschiesser
Newbie
Newbie


Joined: 24 Feb 2009
Online Status: Offline
Posts: 1
Quote eschiesser Replybullet Topic: Filter text string containing certain text
     Posted: 24 Feb 2009 at 6:55am
Hi
I'm using XI and an Oracle DB, and I'm trying to filter the report based on whether or not the "FAMIS_REQ.DESCRIPTION" field contains "too hot" or "too cold" or the like. The field contains other text than just "too hot" or "too cold." For instance, if FAMIS_REQ.DESCRIPTION is the text string "Room 34590 ACF too hot recurring issue" then I want that record to be included in the report.
 
It seems relatively simple, but the command does not exist in Select Expert. I would appreciate any help. Thanks!
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 24 Feb 2009 at 7:03am
instr({table.FAMIS_REQ.DESCRIPTION},"too hot")>0
and
instr({table.FAMIS_REQ.DESCRIPTION},"too cold")>0
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 24 Feb 2009 at 7:05am
Oops that should be an OR statement...
instr({table.FAMIS_REQ.DESCRIPTION},"too hot")>0
or
instr({table.FAMIS_REQ.DESCRIPTION},"too cold")>0
IP IP Logged
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum