Hi there, i am trying to parse a .CSV file with a pretty horrible date format. I am using the Date filter: date { match => [ "HelperDate", "dMMyyyy", "ddMMyyyy" ] } Some example data: 6112019 -> "_dateparsefailure" 1122019 -> "_dateparsefailure" 8032019 -> "_dateparsefailu…

I simulated your date filter and the dates with single digit also fails for me. You can implemente your workaround, add a 0 if the date has 7 digits, using a conditional and some mutate filters. The following config will do: if [HelperDate] =~ /^[0-9]{7}$/ { mutate { rename => { "Help…

Discuss the Elastic Stack

"_dateparsefailure"

Elastic Stack Logstash

RoteEdition (Marvin) July 3, 2021, 5:12pm 4

Thank you so much. Works like a charm! You made my day!

Topic		Replies	Views
Date filter for minor changes in format Logstash	5	329	September 16, 2019
Date filter dateparsefailure Logstash	2	329	February 7, 2020
Help converting the Date format in Logstash - 5.5.0 Logstash	2	661	October 24, 2017
Found a bug in date parsing! Logstash	7	728	February 12, 2018
Failed parsing date in format "dd/MM/yyyy" for specific date Logstash	13	2758	November 19, 2018

Elasticsearch is a trademark of Elasticsearch BV, registered in the U.S. and in other countries
Trademarks
Terms
Privacy
Brand
Code of Conduct

Apache, Apache Lucene, Apache Hadoop, Hadoop, HDFS and the yellow elephant logo are trademarks of the Apache Software Foundation in the United States and/or other countries.

"_dateparsefailure"

Related topics