Page 1 of 1

Not grabbing french date when month is "juin"

PostPosted: Mon Feb 11, 2019 4:49 pm
by travisdee
Hello,

I want to process my electricity bills but am running into an issue.

I'm using the following to grab the date from the document: " du ,31, ,December, ,1999".

It was working great but unfortunately it is skipping dates that have the month June (juin). When I preview the rule, I see that the text does contain what should be registered as a date ( du 1 juin 2017).

Any help would be appreciated!

Re: Not grabbing french date when month is "juin"

PostPosted: Tue Feb 12, 2019 12:03 pm
by Mr_Noodle
Are you using the automatic date detection? Have you tried specifying the format manually?

Also, are those commas supposed to be there?

Re: Not grabbing french date when month is "juin"

PostPosted: Tue Feb 12, 2019 12:14 pm
by travisdee
Here is the date format that I'm using: https://d.pr/lEQtSx. The commas showed up when I copied and pasted the text from the field into my post.

Here is the first date in the document that it is not picking up: https://d.pr/SjFPNi. The date that hazel is picking up is further down in the document and can be seen here: https://d.pr/8NT9Iv.

Thanks!

Edit: here it is with the 2017 document: https://d.pr/OLMkJj

Re: Not grabbing french date when month is "juin"

PostPosted: Wed Feb 13, 2019 10:23 am
by Mr_Noodle
In your pattern, you are selecting the date with both digits underlined. That means you are expecting a two digit date. It won't pick up that first date since the day is a single digit ("4" vs "04"). Try changing that in your pattern.

Re: Not grabbing french date when month is "juin"

PostPosted: Wed Feb 13, 2019 4:51 pm
by travisdee
Ahh! That makes a lot more sense. Thanks for the help!