Cannot get REGEX in Variables to work

Grafana
1

I’m having an issue filtering tags in Grafana with an InfluxDB backend. I’m trying to filter out the first 8 characters and last 2 of the tag but I’m running into a really weird issue.

Here are some of the names…

GYPSKSVLMP2L1HBS135WH
GYPSKSVLMP2L2HBS135WH
RSHLKSVLMP1L1HBS045RD
RSHLKSVLMP35L1HBS135WH
RSHLKSVLMP35L2HBS135WH

I only want to return something like this:

MP8L1HBS225
MP24L2HBS045

I first started off using this expression:

[MP].*

But it only returns the following out of 148:

PAYNKSVLMP27L1HBS045RD
PAYNKSVLMP27L1HBS135WH
PAYNKSVLMP27L1HBS225BL
PAYNKSVLMP27L1HBS315BR

Through StackOverflow, the following solutions should have worked…
(?<=\w{8})\w+(?=\w{2})
MP[A-Z0-9]+(?=[A-Z0-9]{2}$)

2

MP[A-Z0-9]+[0-9]

3

You need to use a capture group in your regex expression, you are only filtering.

/.*(MP[A-Z0-9]+[0-9]).*/

image
image2148×1190 147 KB