topic Re: Get text from content by REGEX in DQL

Extract Text from Content Using REGEX in DQL Queries

thanawat — Thu, 18 Dec 2025 13:57:05 GMT

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?

Re: Get text from content by REGEX

DynaWiz — Wed, 09 Oct 2024 06:47:10 GMT

Try use this regex:

.+\.(.+)$

Re: Get text from content by REGEX

Peter_Youssef — Wed, 09 Oct 2024 07:41:38 GMT

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

Re: Get text from content by REGEX

thanawat — Wed, 09 Oct 2024 07:49:17 GMT

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.

Re: Get text from content by REGEX

Peter_Youssef — Wed, 09 Oct 2024 08:16:11 GMT

Hello @thanawat

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

KR,

Peter