SQL & PL/SQL

Does anyone know if there's another function or a way to specify 2 delimiters INSTR function?


select distinct substr(summary ,1, (INSTR(summary,':',1,1)-1)) as "Dep Error Summary",count(*)
from AAA.BKS_AAA_DEP_ERRORS
where creation_date > to_date('06/21/12 22:28','mm/dd/yy HH24:MI')
group by summary
UNION
select distinct substr(summary ,1, (INSTR(summary,'.',1,1)-1)) as "Dep Error Summary",count(*)
from AAA.BKS_AAA_DEP_ERRORS
where creation_date > to_date('06/21/12 22:28','mm/dd/yy HH24:MI')
group by summary


I’m using a union to return the results on the same row BUT I’m getting extra rows.


Results
Validation Failure 1
Rebilling Failure 468
Derive Party ID Failure 468
Derivation Failure 1
1
468


Any recommendations on how I may eliminate these extra rows?