Splunk Search

How to remove part of my value to create a new value?

Robbie1194
Communicator

Hi guys,

My goal is to remove part of my value to create a new value.

For example, I have a field called created_time = 1517789420.357994. Does anyone know a way of getting newCreatedTime = 1517789420?

I basically just want the .* to go away!

Any help would be appreciated.

Cheers!

0 Karma
1 Solution

micahkemp
Champion
| eval newCreatedTime=floor(created_time)

View solution in original post

cmerriman
Super Champion

@micahkemp 's answer is great, you could also try |eval newCreatedTime =mvindex(split(created_time,"."),0) I only mention this in case you ever need to split a field that isn't numeric. http://docs.splunk.com/Documentation/SplunkCloud/7.0.0/SearchReference/MultivalueEvalFunctions

0 Karma

micahkemp
Champion
| eval newCreatedTime=floor(created_time)
Get Updates on the Splunk Community!

Demo Day: Strengthen Your SOC with Splunk Enterprise Security 8.1

Today’s threat landscape is more complex than ever. Security operation centers (SOCs) are overwhelmed with ...

Dashboards: Hiding charts while search is being executed and other uses for tokens

There are a couple of features of SimpleXML / Classic dashboards that can be used to enhance the user ...

Splunk Observability Cloud's AI Assistant in Action Series: Explaining Metrics and ...

This is the fourth post in the Splunk Observability Cloud’s AI Assistant in Action series that digs into how ...