rex field=_raw "(?<month>\w+)\s\d+\w\w,(?<year>\d\d\d\d)" | eval MON=case(month == "Nov", "11", month == "July", "7", month == "June", "6", month == "Aug", "8") | eval date=year."-".MON | table date MON, year _raw
it gives this output -
date MON year _raw
2014-11 11 2014 the format Nov 10th,2014 and extract out the month_year in the format 2014-06.
2014-8 8 2014 the format Aug 6th,2014 and extract out the month_year in the format 2014-06.
2014-7 7 2014 the format July 1st,2014 and extract out the month_year in the format 2014-06.
2014-6 6 2014 the format June 16th,2014 and extract out the month_year in the format 2014-06.
... View more