Splunk Search

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

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

Champion
| eval newCreatedTime=floor(created_time)

View solution in original post

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

Champion
| eval newCreatedTime=floor(created_time)

View solution in original post