2020.2

SELECT [return key] FROM [group] WHERE [lookup key] = [lookup value];
PDF data selections
These selections are used for PDF data files. The selection refers to a specific area of any
given page of the PDF by using precise region coordinates (in inches).
Note that when adding a metadata field, if you perform a multi-line data selection on a PDF
region, only the first line of that region will be set to the metadata field.
Syntax
region(page, left, top, right, bottom, case option, trim option)
Here is a breakdown of the syntax (all options are mandatory):
l
region(): Always surrounds PDF data selections.
l
Page: The page of the PDF from which to retrieve the data.
l
Left: Exact horizontal position (in inches) that defines the left of the selection region.
l
Top: Exact vertical position (in inches) that defines the top of the selection region.
l
Right: Exact horizontal position (in inches) that defines the right of the selection region.
l
Bottom: Exact vertical position (in inches) that defines the bottom of the selection region.
l
Case Option: This can be one of three options:
l
KeepCase: Keeps the current uppercase and lowercase letters as they are.
l
UpperCase: Converts all letters to their uppercase equivalent.
l
LowerCase: Converts all letters to their lowercase equivalent.
l
Trim Option: Can either be "Trim" if you want to trim empty spaces before and after the
data selection or "NoTrim" if you want to retain the extra spaces.
Metadata selections
Metadata selections are used with any type of emulation, as long as a metadata file was
created by a previous task in the process.
Tip
To get a sample of the metadata file, debug your process and step through it until the
Page 56