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

Question

Question

Is it possible to read the same informations from different canvas of documents in Quickfields

Quick Fields
Updated May 18, 2019
asked on May 16, 2019 • Show version history

Hi LF Community,

 

I have a different types of invoices to treat in QuickFields, i just want to retrieve the amount of each invoice, is there any way to do this knowing that the coordinates of the amounts differs from one other.

 

Best regards.

 

1 0

Answer

SELECTED ANSWER
replied on May 16, 2019 • Show version history

Hi Amir,

Regular expressions in the Pattern Matching process is used for that kind thing.

For example, If you have one invoice that displays:

Total:       £100.00

and another that displays

Total (inc Tax):   1,200.00

You could capture both with a pattern that looks like:

Total\D+([\d\.,]+)

Which tells Laserfiche to:

  • Look for the word "Total".
  • Followed by 1 or more non-numbers.
  • Followed by 1 or more numbers, periods and commas.
  • Finally, return the value inside the brackets (the number, periods, and commas)

-Ben

3 0

Replies

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

Sign in to reply to this post.

Details
Related Posts
Loading ...