You are viewing limited content. For full access, please sign in.

Question

Question

can you OCR $ in quick field session

Quick Fields
Updated October 4, 2016
asked on November 3, 2015

We have a metadata field that has invoice amount (usd currency format) set as the field type. The issue is that when quick fields runs the invoices some of them have the $ in the total. Quick Fields will not let you store the document because of the $. The problem is the $ is so close the the leading number there isn't a way to leave it out. How can this be averted? 

0 0

Answer

SELECTED ANSWER
replied on November 3, 2015 • Show version history

You can use a Substitution process to remove the $ (by replacing it with nothing). 

You'll want to put a backslash before the dollar sign like this: 

    \$ 

to indicate that you want to replace the literal character $ rather than the metacharacter that uses the same $ symbol. 

 

It would look something like this:

2 0
replied on October 4, 2016

Hi Tessa,

Thanks for this response - which has helped me with a demo, and works well.

However, in situations like my demo where there are numerous £ figures being collected off each page, the current system means I have to set-up multiple tokens -> substitutions.

I just wondered if there might be future plans to have a Zone OCR setting of 'Ignore Currency Symbol' for each OCR zone? I think this could be a more elegant solution but understand if there might not be much call for it.

Thanks,

Duncan

 

0 0
replied on October 4, 2016

Hi, 

Thank you for the feedback! As you suspected, I think a setting just for currency symbols might be too specific. However, I think a slightly more generic enhancement - such as the ability to run a Zone OCR and filter out specific characters all within a single step - is something we can definitely look into for future versions. Would that work for you?

2 0
replied on October 4, 2016

Yes absolutely, that would be ideal. Thanks for the swift reply smiley

0 0

Replies

replied on November 3, 2015

You can create a token in the pattern matching object and use the pattern result to exclude the dollar symbol if present.

The pattern might be \$?([\d,\.]+)

0 0
You are not allowed to follow up in this post.

Sign in to reply to this post.

Details
Related Posts
Loading ...