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.
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.