2.80:Row Match (Table Extract Method)
Row Match is one of three methods available to Data Table data elements to extract information from tables on a document set. It uses regular expression pattern matching to determine a tables structure based on the pattern of each row and extract cell data from each column.
About
The configuration of Row Match is relatively simple. As you can see in the image below, there is only one property to configure, the "Row Extractor". Just like any other extractor, it can be an Internal pattern or a Reference to an extractor in the Node Tree.
 |
|
This extractor is made to find the general pattern of each row in a table. Examine the table below.
Each row has a pattern we can match using regular expression. First a date, followed by a five digit number, followed by a name of variable length, followed by a one to two digit number followed by a variable dollar amount. First, we might look at patterns to target each column, one after the other. That might look like something below.
| Regular expression | Match found on image | Notes |
\d{1,2}/\d{1,2}/(\d{2}|\d{4}) |
 |
This pattern is just one of may ways to find this specific date format. This pattern would need to be adjusted to find other formats such as "month-day-year". |
\d{5} |
 |
A simple regex to only find a five digit number. |
[A-Z]+ |
 |
This pattern also matches words outside of the row, but that's ok. We will put this all together and only match the row shortly. |
\d{1,2} |
 |
Same with this pattern. |
[$]\d{1,3}(,\d{3})?[.]\d{2} |
|
Again, one of many ways to match currency values. |
Now that we can match every cell in the row, we just need to put all that information together and match the whole row. We can enable "tab marking" in a pattern to insert the "\t" control character between segments of text separated by a large amount of whitespace (larger than a normal space character). We can use this tab character to make a regular expression pattern seen below to match the entire row.
Version Differences
The Row Match method is the oldest and original method of extracting table data in Grooper. As such, not much has changed from previous versions. However, there are two other table extract methods available in Grooper now, Header-Value and Infer Grid. These methods provide functionality either not available to Row Match, or make configuring table extraction much simpler for certain use cases.
Use Cases
The Row Match method is perfectly suited for fairly simple table structures.