How to find a word using last part of the word from a file

[john]

exception is java.Exception
exception is java.sql.Exception
exception is java.sql.SQLException
exception is java.sql.UmatchedException
exception is java.sql.UpdateException
and so on

This is a content of the file iam working with.I am looking for some unique search query to find out the only Exceptions those having name like(UmatchedException)not just the word Exception.please help me...

[Damien_Dallimor]

Try something like this in your splunk search:

... | rex field=_raw "exception is (?:\w+\.)+(?<exception_name>\w+Exception)"  | stats count by exception_name

[Damien_Dallimor]

Nice. Don't forget to "accept" the answer !

[john]

Thanks Damien its working....................