Not grabbing french date when month is "juin"

Get help. Get answers. Let others lend you a hand.

Moderator: Mr_Noodle

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!
travisdee
 
Posts: 3
Joined: Mon Feb 11, 2019 4:41 pm

Are you using the automatic date detection? Have you tried specifying the format manually?

Also, are those commas supposed to be there?
Mr_Noodle
Site Admin
 
Posts: 7759
Joined: Sun Sep 03, 2006 1:30 am
Location: New York City

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
travisdee
 
Posts: 3
Joined: Mon Feb 11, 2019 4:41 pm

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.
Mr_Noodle
Site Admin
 
Posts: 7759
Joined: Sun Sep 03, 2006 1:30 am
Location: New York City

Ahh! That makes a lot more sense. Thanks for the help!
travisdee
 
Posts: 3
Joined: Mon Feb 11, 2019 4:41 pm


Return to Support

cron