Splunk Search

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

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

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

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

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