I am using filebeat to monitor a directory for new files that get dropped in every hour. The files are then sent to logstash to be parsed before being sent to ES. The filenames are in this format
aldb-E6-20201015232941.csv or possibly
I need to be extract the data
E6 from the filename and add it to the index. Can I do this using logstash?
I know I can get the filepath using
[log][file][path] which returns a value like
/var/data/filebeat/source/aldb-E6-20201015232941.csv, but how can I then extract the information I need from that?