Splunk Search

How to capture the date from my sample inputlookup CSV file?

trevorQmulos
New Member

I have a CSV that has the setup as shown below.

Date     |Score
1/1/2016 | 4.3
2/1/2016 | 5.7 

I need to extract that date to be able to do trends on the scoring. I have no other way to ingest the CSV aside from just using an inputlookup.

0 Karma
1 Solution

sundareshr
Legend

Try this

| inputlookup csvfilename.csv | eval time=strptime(Date, "%-m/%-d/%Y") | bin span=1mon | stats count by time

View solution in original post

0 Karma

sundareshr
Legend

Try this

| inputlookup csvfilename.csv | eval time=strptime(Date, "%-m/%-d/%Y") | bin span=1mon | stats count by time
0 Karma

trevorQmulos
New Member

bin command needed another argument with _time but that did work

| eval _time=strptime(Date, "%-m/%-d/%Y") | bin span=1mon _time |

0 Karma
Get Updates on the Splunk Community!

What's new in Splunk Cloud Platform 9.1.2312?

Hi Splunky people! We are excited to share the newest updates in Splunk Cloud Platform 9.1.2312! Analysts can ...

What’s New in Splunk Security Essentials 3.8.0?

Splunk Security Essentials (SSE) is an app that can amplify the power of your existing Splunk Cloud Platform, ...

Let’s Get You Certified – Vegas-Style at .conf24

Are you ready to level up your Splunk game? Then, let’s get you certified live at .conf24 – our annual user ...