Howto extract a substring from string type query

Grafana Time Series Panel
#1

I’m using InfluxDB and Grafana 8.3.
I’ve also log data in InfluxDB, therefore fields of type string.
I’d like to extract a part of the string from the returned query data and display this in a table.
The field data is like a key=value list, and I need the chars between a prefix and a delimiter.
Best would be a regular expression, like /tag=(.*?),/.
Is there any mechanism in Grafana to do this ?

#2

can you please follow these steps to share your raw unformatted data? That way, the community can try and mock up your problem :+1:

#3

The data comes from log messages of the form

some_text: key1=val1, key2=val2, ...

So a regular expression like /key1=([^,]*)/ would for example extract val1.

#4

For the extraction of variables there is a mechanism to parse and pick, see

But it is, as far as I understand, specific for setting up variables.
What I’m looking for is a mechanism which returns sub-strings which can be visualized with a table panel.