How to find and remove specific word in Elasticsearch

Grafana Elasticsearch
1

Hi all,

Can anyone let me know how to find and remove specific word in Elastic search

for example :
millsec 018ms

I need to remove the text “ms” from 018ms.

2

Hi,

Not sure Grafana can help you with that if you’re referring to removing it in a query result. For this I would suggest you to change how you write documents to your elasticsearch indices. Basically if you have a string value in es and want it to be a numeric one I definitely suggest you to actually write the numeric value with a numeric data type in your es document. If you’re using a template variable you may be able to do it using a regular expression.

Marcus