Splunk Search

Get a value from Search

abhi144
New Member

I have a search which is coming with this field-

timezone=America/Montreal(EDT)offset-14400(Daylight).

so how can i get only EDT? Any suggestion will be appreciated.

Tags (2)
0 Karma

MuS
Legend

Hi,

something like this should work:

... | rex field="timezone" "\((?<myTZ>[A-Z]+)\)" | ...

this will create a new field called myTZ

cheers, MuS

Get Updates on the Splunk Community!

How to Monitor Google Kubernetes Engine (GKE)

We’ve looked at how to integrate Kubernetes environments with Splunk Observability Cloud, but what about ...

Index This | How can you make 45 using only 4?

October 2024 Edition Hayyy Splunk Education Enthusiasts and the Eternally Curious!  We’re back with this ...

Splunk Education Goes to Washington | Splunk GovSummit 2024

If you’re in the Washington, D.C. area, this is your opportunity to take your career and Splunk skills to the ...