Form Recognizer - Allow different decimal symbol

Question

Form Recognizer - Allow different decimal symbol

Kevin 42IT 0

I have some invoice where the provider use both "," and "." as a decimal symbol.

Form Recognizer seems to accept only 1 kind of symbol.

The field is setup as number -> currency and read correctly the value as 43,80 but change it to 4380.

Is there any way to let Form Recognizer knows that both "." and "," are acceptable decimal symbol ?
Or maybe any other way beside changing my fields to string ?

Rohit Mungi 49,126 Reputation points Microsoft Employee Moderator

2023-01-19T07:51:25.6433333+00:00

@Kevin 42IT I believe you are using the custom model to train and analyze the document. Is the form using the same currency sign for both formats i.e $5.4 and $5,4 ?

I think "," is mostly used for euro but if the both the symbols are used with one currency type then this might be a limitation with the field. Can you add the form used here?
Alexander Kastil 1 Reputation point

2023-04-30T21:01:53.4966667+00:00

I have the same issue training a custom model … propper pdf from a bank for stock sales, top quality, german format, traded in € and using “,“ as a separator … 276,95 to 27695