Page 1 of 1

automatic date matcher not finding date

PostPosted: Tue Apr 14, 2020 9:41 am
by stevenmachtelinckx
Hi

I'm seeing behaviour related to date matching which I don't understand.

My document has the following text:
Code: Select all
Bestelling:        01092012   Datum:       15/12/2019


I try to parse the date (the value '15/12/2019' in this case ) with the 'automatically detect date format' feature into a documentdate variable, but the date is not found:
https://drive.google.com/open?id=1DHjdIaVzvpLjSwt-BIcPXbxIqbeeXzBo

Perhaps the auto date match features tries to parse the order number '01092012' as a date, and fails silently?

If I change the order number '01092012' in the document to 'ABCDEF' then the date is found.
Document text in that case:
Code: Select all
  Bestelling:        ABCDEF   Datum:       15/12/2019


https://drive.google.com/open?id=12IMunYXBpWeYF27QZNQriCc1H6QUYOKh

Any idea's how I can make sure the date is found? (I do prefer to continue using the 'automatically detect date format' feature as default date matcher)

Re: automatic date matcher not finding date

PostPosted: Wed Apr 15, 2020 9:43 am
by Mr_Noodle
You would be better off trying to set the date format but if you want to keep using the automatic matcher, try preceding the custom date attribute with the "Datum: " text to give it context.

Re: automatic date matcher not finding date

PostPosted: Thu Apr 16, 2020 2:51 pm
by stevenmachtelinckx
Thank you for the suggestion.
I do prefer to keep using the automatic date format, as I aim to have a generic rule for all scanned documents.

Perhaps then I will check for a specific date format depending on the sender of the document, and use the automatic date format as fallback (if the sender is unknown).

Has anyone done simething similar before?