Excluding some of the words

1

Hi,
Suppose I wan to use regex to reduce the words in variables

e.g. I_USED_GRAFANA

results : GRAFANA

how can I use regex to trim out I_USED and only have GRAFANA

2

Hi,
Suppose I wan to use regex to reduce the words in variables

Tell us what you mean by “reduce the words”.

Do you mean “remove specific words if they exist”?

Do you mean “remove all words except the last one”?

Do you mean “remove everything except certain words”?

Do you mean something else?

e.g. I_USED_GRAFANA

results : GRAFANA

how can I use regex to trim out I_USED and only have GRAFANA

We need to know whether your regex is supposed to say “delete ‘I_USED’ and
leave whatever’s left”, or “remove everything except ‘GRAFANA’” or “chop
everything up to and including the last underscore and leave the remainder”…

Also, where do you want to use this regex? In a data query? If so, what is
your data store back-end?

Regards,

Antony.

3

I am creating a viariables for filtering so the words are too long I want to remove some and leave last words

here is the results:
_LM_W3SVC_ROOT_Me
_LM_W3SVC_ROOT_you

so I want to exclude everything and leave “me”, and “you”
to ease filter readings