Splunk Search

IF then problems...

jacqu3sy
Path Finder

struggling with the following IF statement....

I have a table, and want to create a new field called 'finalclosedtime' which will be populated either by an existing field called 'closedtime' or a string IF one of the other fields contains a value of "New".

I tried this but no joy:

| eval finalclosedtime=if((status_label="New",stringtopopulate)closedtime)

Any ideas? Thanks.

Tags (1)
0 Karma
1 Solution

dineshraj9
Builder

You can form the field this way -

| eval finalclosedtime=if(like(status_label,"%New%"),stringtopopulate,closedtime)

View solution in original post

paulbannister
Communicator

Hi There, try it simply as:

| eval finalclosedtime=if(status_label="New", stringtopopulate, closedtime)

jacqu3sy
Path Finder

Also worked, thanks!

0 Karma

dineshraj9
Builder

You can form the field this way -

| eval finalclosedtime=if(like(status_label,"%New%"),stringtopopulate,closedtime)

jacqu3sy
Path Finder

Thats so simple, took me ages trying to get that working! many thanks!

0 Karma

DalJeanis
Legend

Great! Please accept the answer that solved the problem, and upvote any other answers that you found particularly helpful.

0 Karma

dineshraj9
Builder

no problem 🙂

0 Karma
Get Updates on the Splunk Community!

Splunk Answers Content Calendar, July Edition I

Hello Community! Welcome to another month of Community Content Calendar series! For the month of July, we will ...

Secure Your Future: Mastering Upgrade Readiness for Splunk 10

Spotlight: The Splunk Health Assistant Add-On  The Splunk Health Assistant Add-On is your ultimate companion ...

Observability Unlocked: Kubernetes & Cloud Monitoring with Splunk IM

Ready to master Kubernetes and cloud monitoring like the pros? Join Splunk’s Growth Engineering team on ...