Splunk Search

All fields from a lookup.csv file appear except the date field?

boris
Path Finder

All fields from a lookup.csv file appear as available search fields except the date field.

Here is how I defined the start_date field in my lookup.csv file:

'2012-03-12 20:10'

%Y-%m-%d %H:%M

So how can I get this start_date field to appear as a potential field in my searching here?

0 Karma
1 Solution

boris
Path Finder

After looking at the raw .csv of the lookup file I see the dates were formatted differently then I expected.

View solution in original post

0 Karma

boris
Path Finder

After looking at the raw .csv of the lookup file I see the dates were formatted differently then I expected.

0 Karma

boris
Path Finder

Thanks MarioM. After looking at the raw .csv of the lookup file I see the dates were formatted differently then I expected.

0 Karma

MarioM
Motivator

can you post an extract of your lookup.csv with the header?

Get Updates on the Splunk Community!

[Puzzles] Solve, Learn, Repeat: Character substitutions with Regular Expressions

This challenge was first posted on Slack #puzzles channelFor BORE at .conf23, we had a puzzle question which ...

Shape the Future of Splunk: Join the Product Research Lab!

Join the Splunk Product Research Lab and connect with us in the Slack channel #product-research-lab to get ...

Auto-Injector for Everything Else: Making OpenTelemetry Truly Universal

You might have seen Splunk’s recent announcement about donating the OpenTelemetry Injector to the ...