How to trim some part of selected data from InfluxDB in Grafana

[ivbtar]

I have below data in grafana, coming from influxDB.

Data in InfluxDB :

I am using Influx DB 1.7 with Grafana. When i display above data in Grafana the Client Names are coming with () like Res1(4234), Res2(4254)… But i want to display Client Names in Grafana as Res1, Res2 like below.

Grafana Table :

I am writing grafana sql query as below.

Select Code,id,Client_Name,Policy from xtable

How can i trim (4234) paranthesis with numbers from Client_Names in Grafana sql.

[mattabrams]

@ivbtar

Res1(4234), Res2(4254)

@ivbtar use regex-based value mappings like this:

How to Rename Values in Grafana Using Regex-Based Value Mapping

@fadjar340 Here are the new Grafana docs for regex-based value-mapping. And here is an example, using your data. I copied your string value, but not exactly [CleanShot 2021-09-28 at 13.01.37@2x] Chose the new Regex option: [CleanShot 2021-09-28 at 13.02.26@2x] Here is my rather ugly regex with a capture group for the user IDs: [CleanShot 2021-09-28 at 13.02.35@2x] And there you go! [CleanShot 2021-09-28 at 13.02.47@2x] When I first saw this PR get merged, I was so exci…

[ivbtar]

Thanks alot my friend.

[ivbtar]

One more question. Can we apply this value mapping also to variables in filters? Client_Name variable in filters also come with (4234) paranthesis.

[mattabrams]

If you can see it inside the table panel, you should be able to modify it. I don’t think value-mapping extends into in the inner workings of template variables, but I’m not sure

[mattabrams]

at some point it might be more useful to fix these sorts of issues on the database side, just to make life easier in Grafana. That is, if you can

[ivbtar]

You are right. But the data is influxdb. I have 10.000 s of data like this. InfluxDB does not allow to update added records.It is a time series db. Do you know Influxdb ? Is it possbile to clean these pharanthesis () in Influxdb database side?