Hazel finds wrong date in document

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

Moderator: Mr_Noodle

Re: Hazel finds wrong date in document Tue Feb 22, 2022 9:37 am • by Mr_Noodle
Do you have a sample document (with personal info redacted) that you can email in to support?
Mr_Noodle
Site Admin
 
Posts: 11285
Joined: Sun Sep 03, 2006 1:30 am
Location: New York City

Re: Hazel finds wrong date in document Mon Feb 28, 2022 10:36 am • by Mr_Noodle
Got your file. It works fine for me here. Have you tested against that specific file? If it still doesn't work, can you email (not private message) me the rules you are using?
Mr_Noodle
Site Admin
 
Posts: 11285
Joined: Sun Sep 03, 2006 1:30 am
Location: New York City

Re: Hazel finds wrong date in document Mon Feb 28, 2022 10:44 am • by hazelcamaso
Yes, that is the file. There are many others.
Rule screenshot follows by email.
hazelcamaso
 
Posts: 9
Joined: Fri Feb 11, 2022 7:48 am

Re: Hazel finds wrong date in document Fri May 10, 2024 8:57 am • by roberting
has this been solved yet?

I have a similar issue where hazel would not find the first date in the PDF. However, the parsed string in the preview clearly shows the first date (no strange characters in between), but the second date is recognized instead. (I tried both auto date and a customized date pattern)
I assume that the text in the preview window is the raw text extracted from the pdf and that's the text that is used to detect the patterns? The first rows of the extracted text from the preview are as follows (dashes are redacted info).

the date I need to extract is in line 12: 05/04/2024 (fifth of April), hazel recognizes the first of march 2024 further down:

Microsoft Iberica S.R.L. Paseo Club Deportivo 1, Pozuelo de Alarcón, 28223, Madrid,
Spain.
VAT Reg. No. ESB78603495
Sold To
---------------
---------------
---------------
ES
Summary
Billing Profile Billing Number Document Date
Questions on your bill? Visit https://aka.ms/invoice-billing
--------------- (ES) --------------- 05/04/2024
Bill To
---------------
---------------
---------------
---------------
ES
This invoice is for the billing period 01/03/2024 - 31/03/2024
This bill contains the charges for your purchases and services consumed from Microsoft. Find more details about your bill at ...
roberting
 
Posts: 7
Joined: Mon Apr 18, 2022 9:40 am

Re: Hazel finds wrong date in document Fri May 10, 2024 10:55 am • by Mr_Noodle
Can you post your rule/date pattern?
Mr_Noodle
Site Admin
 
Posts: 11285
Joined: Sun Sep 03, 2006 1:30 am
Location: New York City

Re: Hazel finds wrong date in document Fri May 10, 2024 1:38 pm • by roberting
Mr_Noodle wrote:Can you post your rule/date pattern?


I tried automatic date detection, that actually found the 3rd date in the document (31/03/2024), and
also with a pattern with tokens: 31/12/1999, which also found the 31/03/2024
roberting
 
Posts: 7
Joined: Mon Apr 18, 2022 9:40 am

Re: Hazel finds wrong date in document Mon May 13, 2024 8:34 am • by Mr_Noodle
Try searching for the specific text (05/04/2024) without copy and pasting it. I suspect there might be some hidden characters in there.
Mr_Noodle
Site Admin
 
Posts: 11285
Joined: Sun Sep 03, 2006 1:30 am
Location: New York City

Previous

Return to Support