Skip to Content
0
Former Member
Jun 08, 2010 at 01:14 PM

count from a string

11 Views

i am using this formula

{USR_CR_RISK_CHANGE;1.DETAIL}[instrrev({USR_CR_RISK_CHANGE;1.DETAIL},'OLD: LowRisk')-1 to length({USR_CR_RISK_CHANGE;1.DETAIL})];

this retrieves

OLD: LowRisk NEW: MediumRisk

which is what i want

i want to then get a count of how many risk changes there were from low to medium

the original string looks like this

| LastOper OLD: SQLUSER NEW: LUCI01| LastModify OLD: May 11 2009 10:03AM NEW: May 11 2009 12:17PM| RiskClass OLD: LowRisk NEW: MediumRisk

if there is a way to get a count from the original string that would work also

thanks