I have some textual data (snort alert messages) I would like to do a regex of a field and then an aggregation (count by day) of the results of that regex'd field. For instance:
data:
"01/01/2016","WEB more words here"
"01/01/2016","WEB different words"
"01/01/2016","MS-SQL woooorrrddssss"
I regex out to just the Caps bit at the beginning to get for that day:
"WEB",2
"MS-SQL",1
I can't quite figure out if Kibana can DO that, or how to do it if it can.