{"id":24168,"date":"2024-09-26T16:22:53","date_gmt":"2024-09-26T14:22:53","guid":{"rendered":"https:\/\/help.openbee.com\/open-bee-scan-capture\/knowledge-base\/how-to-guides\/why-is-there-no-longer-auto-regex-generation-for-decimal-numeric-or-date-indexes\/"},"modified":"2026-05-13T09:39:39","modified_gmt":"2026-05-13T07:39:39","slug":"why-is-there-no-longer-auto-regex-generation-for-decimal-numeric-or-date-indexes","status":"publish","type":"page","link":"https:\/\/help.openbee.com\/en\/open-bee-scan-capture\/knowledge-base\/how-to-guides\/why-is-there-no-longer-auto-regex-generation-for-decimal-numeric-or-date-indexes\/","title":{"rendered":"Why is there no longer auto-regex generation for decimal, numeric, or date indexes?"},"content":{"rendered":"\n

General<\/h2>\n\n

In order to optimize this functionality, we have restricted the use of regex auto-generation for Date, Decimal, and Numeric indexes.<\/p>\n\n

For these indexes, the basic regexes present within the software allow you to detect most of the desired values. If the value is not detected, research efforts must be focused on: the area, the discrepancies between the amounts, the rules, etc. <\/p>\n\n

Decimal and numerical indexes<\/h2>\n\n
\n

For example, decimal and numeric values change lengths very often.If we take the case of an invoice amount, this value can take different forms: 1.42 or 35.48 or 3652.45 … All of these values can be found natively by Capture, so there’s no need to use auto-generation. However, when the values were not found due to bad customizations or other manipulations, the end user tended to use auto-generation thinking to correct the problem. Not only did this not correct the first problem, but it had the effect of aggravating it since after auto-generation, Capture obtained a very strict regex to look for as a favorite. Ex auto-generation on the value 1.45<\/strong> led Capture to only search for values corresponding to a digit, followed by a comma, followed by a digit, followed by a digit<\/strong>.The software could therefore no longer find an amount like 125.56. <\/p>\n<\/blockquote>\n\n

Example scenario<\/h3>\n\n

Let’s take the case of this invoice, simple customization areas allow you to find the values<\/p>\n\n

\"\"<\/figure>\n\n

Consider the following customer scenario:<\/strong> <\/p>\n\n

An invoice from the same supplier arrives with an OCR error<\/p>\n\n

\"\"<\/figure>\n\n

As usual, the customer uses the regex auto-generation since the amounts are not found<\/p>\n\n

\"\"<\/figure>\n\n

He therefore finds himself with a new regex as the favorite in his list of regexes<\/p>\n\n

\"\"<\/figure>\n\n

This new regex: ((^|\\s|(?<=\\:)|(?<=\\;)|(?<=\\,)|(?<=\\\u00b0)|(?<=\\.)|(?<=\\())[0-9][0-9],[0-9][a-zA-Z])(\\s|$|(? =\\.)|(?=\\,)|(?=\\;)|(?=\\))) <\/em>Now only accepts values of type 1 digit 1 digit decimal point one digit one letter<\/strong><\/p>\n\n

If we look at the invoice after generation, it didn’t solve the problem of amount, the 26 is still not found<\/p>\n\n

\"\"<\/figure>\n\n

But worse still, it has worsened the situation, if we look at our invoice which was correctly recognized before this manipulation, it is no longer because of this new regex<\/p>\n\n

\"\"<\/figure>\n\n

Case study (Customer)<\/h3>\n\n

Here is a concrete case found in a client, which illustrates what is very often found in clients complaining about recognition that no longer works<\/p>\n\n

\"\"<\/figure>\n\n
\"\"<\/figure>\n\n
\"\"<\/figure>\n\n

The engine is throttled on all sides with auto-generated regexes, so there is no longer any chance of being able to find the amounts of this document<\/p>\n\n

Index dates<\/h2>\n\n

In the case of date-type indexes, especially for dates with months written in letters, we ran into the same danger. Indeed, if we take for example the date March 1, 2020<\/strong>, auto-generation on this value resulted in the creation of a regex A number, a space, a letter, a letter, a letter, a letter, a space, a number, a number, a number, a number.<\/strong>The software could therefore no longer find the value on November 25, 2020. Another problem in the case of date indexes is that, in addition to the regex, it is necessary to tell Capture the format of the date, e.g. dd MMMM yyyyy,<\/strong> so that it can associate the value found with a Date object. In the majority of cases, the format was not populated by users due to lack of knowledge, which had the effect of blocking the search for Capture with a self-generated but unusable favorite regex. <\/p>\n\n

\"\"<\/figure>\n","protected":false},"excerpt":{"rendered":"

General In order to optimize this functionality, we have restricted the use of regex auto-generation for Date, Decimal, and Numeric indexes. For these indexes, the basic regexes present within the software allow you to detect most of the desired values. If the value is not detected, research efforts must be focused on: the area, the […]<\/p>\n","protected":false},"author":97,"featured_media":0,"parent":21191,"menu_order":13,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-24168","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/help.openbee.com\/en\/wp-json\/wp\/v2\/pages\/24168","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/help.openbee.com\/en\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/help.openbee.com\/en\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/help.openbee.com\/en\/wp-json\/wp\/v2\/users\/97"}],"replies":[{"embeddable":true,"href":"https:\/\/help.openbee.com\/en\/wp-json\/wp\/v2\/comments?post=24168"}],"version-history":[{"count":1,"href":"https:\/\/help.openbee.com\/en\/wp-json\/wp\/v2\/pages\/24168\/revisions"}],"predecessor-version":[{"id":24169,"href":"https:\/\/help.openbee.com\/en\/wp-json\/wp\/v2\/pages\/24168\/revisions\/24169"}],"up":[{"embeddable":true,"href":"https:\/\/help.openbee.com\/en\/wp-json\/wp\/v2\/pages\/21191"}],"wp:attachment":[{"href":"https:\/\/help.openbee.com\/en\/wp-json\/wp\/v2\/media?parent=24168"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}