Reg Expression for specific String

[Luke_Nguyen]

I'm trying to capture the check amount that is in a box in the following format $****6,897.71  .  I haven't been able to get the numeric value back in a consistent manner with the suspect level below 90.  Any ideas how I can improve this?  Use a regular expression?  Thanks.

[Steve_Reed · Accepted solution]

The simplest way to extract it might be to set the filtering to all character types, and then in the 'specific allowed characters' field, enter the values: 0123456789.  (note the period on the end)

This way the engine will attempt to read everything, then before assigning to the keyword, it will remove all characters except for the allowed ones (the numeric digits and the decimal point).

[Steve_Reed · Accepted solution]

The simplest way to extract it might be to set the filtering to all character types, and then in the 'specific allowed characters' field, enter the values: 0123456789.  (note the period on the end)

This way the engine will attempt to read everything, then before assigning to the keyword, it will remove all characters except for the allowed ones (the numeric digits and the decimal point).

[Luke_Nguyen]

That's how I currently have it configured currently.  The issue appears to be those pesky asterisks.  I'm not sure why, but it makes the OCR engine return extra digits.

[Steve_Reed]

Is the issue that some/all of the asterisks are being misread as numeric digits?

[Luke_Nguyen]

Yes, that is correct.  Most of the times it would always be an extra digit for the first number in the sequence.  In this example 66,897.71.  Everything is checked in Filtering except MICR data as well.