Extract Text from Content Using REGEX in DQL Queries

[thanawat]

I have this message "Exception org.springframework.web.servlet.resource.NoResourceFoundException".

I want to find the latest section of this message which is "NoResourceFoundException".
I prefer to find the text after latest "." dot.

Can I do this?

[DynaWiz]

Try use this regex:

.+\.(.+)$

[Peter_Youssef]

Hi @thanawat 
you can create a query to return the value after "."

or create a rule to fetch exact message in the exception after "."

BR,

Peter

[thanawat]

Hi @DynaWiz , @Peter_Youssef 
thank for your suggestion. Could you share the link for the solution that you mention?
I mean how to use regex with DQL or example query to get expected value.

[Peter_Youssef · Accepted solution]

Hello @thanawat 

10 - 15 Minutes reading and you will be able to develop it 

1. DQL 
2. DQL Commands 
3. How to use DQL queries 

KR, 

Peter