Back to results
US 2021/0240973 A1Published application
Extracting data from tables detected in electronic documents
AssigneeOracle International Corporation
InventorsErhan Erdemir, Kenneth James Peterka
Life of this patent
Estimating the term…
Abstract
The embodiments disclosed herein relate to extracting table data from an electronic document. Tables are detected based on identification of the column headers, of the table, that correspond to known fields. Once a table is detected, values corresponding to the column headers are extracted and stored in association with the known fields.
Claims23
A non-transitory computer readable medium comprising instructions which, when executed by one or more hardware processors, causes performance of operations comprising:
- detecting a plurality of phrases in an electronic document that are (a) on a same first text line and (b) correspond respectively to a plurality of known fields,
- wherein a first phrase of the plurality of phrases corresponds to a first field of the plurality of known fields,
- wherein a second phrase of the plurality of phrases corresponds to a second field of the plurality of known fields,
- wherein the first phrase and the second phrase correspond to column headers in a table in the electronic document;
- extracting data from the table in the electronic document at least by:
- responsive at least to determining that a first value has (a) a corresponding horizontal position in the electronic document that at least partially overlaps with a horizontal position of the first phrase in the electronic document and (b) a corresponding vertical position in the electronic document that is below a vertical position of the first phrase in the electronic document:
- storing the first value in association with the first field that corresponds to the first phrase;
- responsive at least to determining that a second value has (a) a corresponding horizontal position in the electronic document that at least partially overlaps with a horizontal position of the second phrase in the electronic document and (b) a corresponding vertical position in the electronic document that is below a vertical position of the second phrase in the electronic document:
- storing the second value in association with the second field that corresponds to the second phrase.
6 more elements
A method comprising:
- detecting a plurality of phrases in an electronic document that are (a) on a same first text line and (b) correspond respectively to a plurality of known fields,
- wherein a first phrase of the plurality of phrases corresponds to a first field of the plurality of known fields,
- wherein a second phrase of the plurality of phrases corresponds to a second field of the plurality of known fields,
- wherein the first phrase and the second phrase correspond to column headers in a table in the electronic document;
- extracting data from the table in the electronic document at least by:
- responsive at least to determining that a first value has (a) a corresponding horizontal position in the electronic document that at least partially overlaps with a horizontal position of the first phrase in the electronic document and (b) a corresponding vertical position in the electronic document that is below a vertical position of the first phrase in the electronic document:
- storing the first value in association with the first field that corresponds to the first phrase;
- responsive at least to determining that a second value has (a) a corresponding horizontal position in the electronic document that at least partially overlaps with a horizontal position of the second phrase in the electronic document and (b) a corresponding vertical position in the electronic document that is below a vertical position of the second phrase in the electronic document:
- storing the second value in association with the second field that corresponds to the second phrase;
- wherein the method is performed by at least one device including a hardware processor.
7 more elements
A system comprising:
- at least one hardware processor;
- the system storing instructions which, when executed by the at least one hardware processor, cause performance of operations comprising:
- detecting a plurality of phrases in an electronic document that are (a) on a same first text line and (b) correspond respectively to a plurality of known fields,
- wherein a first phrase of the plurality of phrases corresponds to a first field of the plurality of known fields,
- wherein a second phrase of the plurality of phrases corresponds to a second field of the plurality of known fields,
- wherein the first phrase and the second phrase correspond to column headers in a table in the electronic document;
- extracting data from the table in the electronic document at least by:
- responsive at least to determining that a first value has (a) a corresponding horizontal position in the electronic document that at least partially overlaps with a horizontal position of the first phrase in the electronic document and (b) a corresponding vertical position in the electronic document that is below a vertical position of the first phrase in the electronic document:
- storing the first value in association with the first field that corresponds to the first phrase;
- responsive at least to determining that a second value has (a) a corresponding horizontal position in the electronic document that at least partially overlaps with a horizontal position of the second phrase in the electronic document and (b) a corresponding vertical position in the electronic document that is below a vertical position of the second phrase in the electronic document:
- storing the second value in association with the second field that corresponds to the second phrase.
8 more elements
Dependencies are inferred from the claim text.