I am using the below cluster search
| cluster t=0.1 showcount=t countfield=no_of_events | table _time,no_of_events _raw | sort -no_of_events | dedup no_of_events
in the output iam getting the entire raw message as in the table. however, i want to show only the error message.
Is there any way to extract only specific messages instead of full raw message
That very much depends on the difference between raw message and the error message you are looking for. The whole point of Splunk in my view is the freedom to extract any token into data field. But you have to show what raw message contains and which part you consider an error message. (Anonymize as needed.)