Question

Quickfields - Multi-value field

Quick Fields Pattern Matching and Regular Expressions

Updated September 22, 2020

asked on September 18, 2020

I am trying to pull all of the cell phone numbers off of a cell bill. I set up my pattern matching token so it is a multi-value field and I have feeding into a multi-value field in my template. However I am having two issues:

1) if I do not specify a page to find the pattern on (which I need the OCR to search all pages of the document for this information) it will leave the field blank as it will replace the hits it found with what it found only on the last page (which is often nothing)

2) if I specify the page to find the pattern on it will only enter in the first value it finds into the template and not all of the values the pattern matching token is finding.

I know that in both of these scenarios the Pattern matching is working and is pulling all of the info I need from the document into the token ( I can see as much in my processing information). I just can't figure out how to get the token to fill into my metadata template.

I think I am missing a step I just don't know what it is. This is my first time working with multi-value fields/tokens

0 0

Answer

SELECTED ANSWER

replied on September 18, 2020

Hi Tegan,

You may need to use the Token Accumulator process. Here's the online help file. This process will accumulate a multi-value token over multiple pages, which sounds like what you're trying to do. It's been a while since I've had to use that, and I don't have access to a Quick Fields installation right now to verify, but I believe you basically tell it to accumulate the token you get from your Pattern Matching activity, and then you put the Token Accumulator token into the field value you're trying to fill.

Hope that works for you!

1 0

Replies

replied on September 18, 2020

This worked perfectly, but if there is a blank (no value) then it enters %(token name) as a result it looks like this:

(numbers have been changed for privacy reasons

Is there a way to get it to return a blank value if there is nothing found?

0 0

View 1 previous reply

replied on September 18, 2020 • Show version history

Are those blank tokens coming from a Pattern Matching activity? If so, the only thing that stands out to me is to check and make sure the box at the bottom of this screenshot isn't checked for each of those tokens within the Pattern Matching process. I could be wrong on this - this setting may not be related to what you're experiencing.

Let me know what you find out!

0 0

replied on September 22, 2020

No it isn't the bottom box there. What is happening is if the pattern matching value is blank the token accumulator is entering in the pattern matching field name instead of just leaving the value blank. Any ideas on how to get it to leave a blank token blank?

0 0

replied on September 22, 2020

I figured it out. I had them pulling as multi-values. once I switched it back to single token it worked perfect! Thank you for all your help!

1 0

replied on September 22, 2020

Great! That's good to know, as that exact issue you had is something that routinely gives me trouble. Thanks!

1 0

You are not allowed to follow up in this post.

Question

Question

Quickfields - Multi-value field

Answer

Replies

Sign in to reply to this post.