Splunk Enterprise

rex field

shreyasamin64
Explorer

Need help on trimming the month from the field 

EX:  Input      November 29, 2021 2:02:33 PM 

        output   Nov 29, 2021 2:02:33 PM 

for all month in the field 

Thanks 

Labels (1)
0 Karma
1 Solution

richgalloway
SplunkTrust
SplunkTrust

Try this

| rex mode=sed "s/(\w{3})\w* (.*)/\1 \2/g"
---
If this reply helps you, Karma would be appreciated.

View solution in original post

richgalloway
SplunkTrust
SplunkTrust

Try this

| rex mode=sed "s/(\w{3})\w* (.*)/\1 \2/g"
---
If this reply helps you, Karma would be appreciated.
Get Updates on the Splunk Community!

Index This | What is broken 80% of the time by February?

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

Unlock Faster Time-to-Value on Edge and Ingest Processor with New SPL2 Pipeline ...

Hello Splunk Community,   We're thrilled to share an exciting update that will help you manage your data more ...

Splunk MCP & Agentic AI: Machine Data Without Limits

Discover how the Splunk Model Context Protocol (MCP) Server can revolutionize the way your organization uses ...