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!

See just what you’ve been missing | Observability tracks at Splunk University

Looking to sharpen your observability skills so you can better understand how to collect and analyze data from ...

Weezer at .conf25? Say it ain’t so!

Hello Splunkers, The countdown to .conf25 is on-and we've just turned up the volume! We're thrilled to ...

How SC4S Makes Suricata Logs Ingestion Simple

Network security monitoring has become increasingly critical for organizations of all sizes. Splunk has ...