How to use DQL to extract a substring after/before/between a certain character?

waikeat_chan — Thu, 03 Apr 2025 01:40:05 GMT

In DQL, splitString and substring couldn't achieved what I want.

Before this, I can always try to be creative and use other kind of DQL function/command or manipulations and achieved what I want. But today there is just this one problem I couldn't solve, hence asking this question here.

In the Unix world, we can use awk, grep, sed, tail (or any combinations). It seems like it DQL there isn't this much freedom though.

Don't get me wrong, DQL is good and powerful for querying data in Grail, but when it comes to string manipulation it seems to be can be a bit lacking sometimes.

Anyway, the problem I'm facing is as below:

I want to extract the reason of pods not healthy as shown in the last column of screenshot below, how can I use DQL to extract the part before? (i.e to extract only the string before \\\"}]}\", \"{\\\"events ?)

Best Regards,

Wai Keat

Re: How to use DQL to extract a substring after/before/between a certain character?

marco_irmer — Fri, 04 Apr 2025 21:52:42 GMT

You can use the parse command combined with a DPL pattern to extract the data you need into a new field.

topic Re: How to use DQL to extract a substring after/before/between a certain character? in DQL

How to use DQL to extract a substring after/before/between a certain character?

Re: How to use DQL to extract a substring after/before/between a certain character?