Extracts all lines below the anchor line on the current page if:

  • The anchor line's left and right boundaries ("x extent") contain the target lines' x extent, or vice versa.

    Or:

  • The anchor line and target lines overlap by at least 50% of the narrower line's x extent.

Parameters
Examples

Parameters

keyvaluesdescription
id (required)column
tiebreakerfirst, second, third, last, >, <Which line in the column is the target. Use the comparisons > and < to extract maximum and minimum values in the column. Lines are sorted alphanumerically using unicode values. If you want to compare numeric amounts and ignore non-numbers in the row, then add a numeric type such as type: currency as a top-level parameter to the field.
includeAnchortrue, false. default: falseIncludes the anchor line in the method output

Examples

The following example shows that:

  • By default, Sensible returns the entire column as a joined string.
  • Specifying a tiebreaker returns single element in the column.

Config

{
  "fields": [
    {
      "id": "example_column",
      "anchor": "may 2020",
      "type": "string",
      "method": {
        "id": "column"
      }
    },
    {
      "id": "example_column_2",
      "anchor": "may 2020",
      "type":"number",
      "method": {
        "id": "column",
        "tiebreaker": ">"
      }
    }
  ]
}

Example document
The following image shows the example PDF used with this example config:

Click to enlargeClick to enlarge

Example PDFDownload link

Output

{
  "example_column": {
    "type": "string",
    "value": "1 3 2 4 5"
  },
  "example_column_2": {
    "source": "5",
    "value": 5,
    "type": "number"
  }
}

Did this page help you?