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

Question

Question

Extract the value in Quick Fields

asked on June 22, 2021

Is there a way to extract a value from an OCR Omni zone?

I have an OCR Zone that extracts value like this $1,483.00 or $368.78 or $4.58. So these dollar amount can vary through out the page. What I am wanting is only the digits. Like 148300 or 36878 or 458

0 0

Replies

replied on June 23, 2021

Hi Carlos-

Is your Zone getting just dollar amounts, or other text, too? If other text, I think you'll need 2 Pattern Matching activities in your QF session. The first to look for the dollar amounts, since it can get tricky with a variable number of commas. This pattern looks for a string that starts with a dollar sign, has multiple characters that are not whitespace, then ends with a decimal and 2 digits.

[$]\S+[.]\d\d

That pattern can then be the seed of another Pattern Matching token (WF lets you target tokens within a single PM but looks like QF requires a second PM activity).

Step 2: point to the dollar amount token, or Zone OCR if that's already getting you what you need.

Use Pattern Matching to get just the digits within a string, with the setting to return all matches combined with now spaces.

1 0
replied on June 23, 2021

Cool, thanks

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

Sign in to reply to this post.