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

[trevorQmulos]

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.

[sundareshr · Accepted solution]

Try this

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

[trevorQmulos]

bin command needed another argument with _time but that did work

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