Can REGEX parse out 3 unknown characters starting at a fix position in a variable?

Grafana Dashboards
1

I need to create a selection window in a Grafana dashboard that only shows 3 characters that’s been parsed from a hostname queried from InfluxDB. I’m able to query the hostname as a variable; can REGEX be used to parse out the 3 unknown characters starting at a fix position? The hostname length will always be 8 characters and I need to parse out characters 4,5 and 6 from the string. The 3 characters represents airport codes. If possible, please provide a REGEX example.

— examples—
Hostname:
ABCSEA31
ROUORD45
ZXCSMF23

Desired REGEX output to be used as variables in dashboard selection window.
SEA
ORD
SMF

  • What Grafana version and what operating system are you using?
    v6.3.7

  • What are you trying to achieve?
    Uses REGEX as a Query Options under Settings->Variable.

  • How are you trying to achieve it?

  • What happened?

  • What did you expect to happen?

  • Can you copy/paste the configuration(s) that you are having problems with?

  • Did you receive any errors in the Grafana UI or in related logs? If so, please tell us exactly what they were.

  • Did you follow any online instructions? If so, what is the URL?

2

I would do it in influx itself. Also what is the reason behind this?

Are you using influxql or flux query language?

Never mind, you are using an unsupported version of grafana. 6?

3

There are several locations imbedded with the same airport code. I need to create a stack graph of total traffic utilization group by airport codes.