topic Re: regex in Dashboards & Visualizations

regex

SN1 — Thu, 12 Dec 2024 08:54:39 GMT

hi , I want to extract from this date

12/11/2024

result should be 12/2024

Re: regex

gcusello — Thu, 12 Dec 2024 09:04:47 GMT

Hi @SN1 ,

if this is a field (your_field), the easiest way it to use the eval functions, not a regex:

| eval date=strftime(strptime(your_field,"%m/%d/%Y"),"%m/%Y")

Ciao.

Giuseppe

Re: regex

ITWhisperer — Thu, 12 Dec 2024 09:56:23 GMT

Apart from what @gcusello says, rex will only extract contiguous characters into a field, so what you are asking for is not possible in a single rex command.