Error in String Function

[jzalma]

I have a set of data that I am attempting to count the number of times a string appears. My data set includes both "Deferred Dismissal" and "Dismissal"

I need to find a way to count the number of times Dismissal appears and the number of times that Deferred Dismissal appears (they are not the same)

I first attempted

if instr ({'Administrative_Action_Report_'.Sanctions: Sanction},"Dismissal")>0 then 1

but that returned values for both Dismissal and Deferred Dismissal

I then attempted

if instr ({'Administrative_Action_Report_'.Sanctions: Sanction},"Dismissal")>0 and
not ({'Administrative_Action_Report_'.Sanctions: Sanction} in ["Deferred"]) then 1

however this did not change the output.

Any suggestions would be greatly appreciated.

 

[Charliy]

Are there other options for this field? Do any of the other options begin with "Deferred"?

 

[bdreed35]

How about just trying this:

if instr ({'Administrative_Action_Report_'.Sanctions: Sanction},"Dismissal")>0 and
   instr ({'Administrative_Action_Report_'.Sanctions: Sanction},"Deferred")=0 then 1 else 0

~Brian

 

[CoSpringsGuy]

two formulas

if instr ({'Administrative_Action_Report_'.Sanctions: Sanction},"Dismissal")>0 
and len(trim({'Administrative_Action_Report_'.Sanctions: Sanction})) = 8
then 1

if instr ({'Administrative_Action_Report_'.Sanctions: Sanction},"Dismissal")>0 
and len(trim({'Administrative_Action_Report_'.Sanctions: Sanction})) > 8
then 1

Sum each of them at the desired group level or report footer
_____________________________________
Crystal Reports 2011 and XI
Intersystems Cache 2012 ODBC connection


_____________________________________
Crystal Reports 2011 and XI
Intersystems Cache 2012 ODBC connection

 

[SkipVought]

You got to look for Deferred Dismissal BEFORE you look for Dismissal!

Could you post several full text values that are typical of what you are searching?

Skip,
[sub]
Just traded in my OLD subtlety...
for a NUance![/sub]

 

[BettyJ]

Try

@findstring
[tt]if "Deferred Dismissal" in {'Administrative_Action_Report_'.Sanctions: Sanction} then
1
else if "Dismissal" in {'Administrative_Action_Report_'.Sanctions: Sanction} then
2
else
0
[/tt]

Then you need to write formulas to count 1's to get the count of Deferral Dismissal and 2's to get the count of Dismissal.

Hope this helps.