PDF extraction with text-based key
The present disclosure includes a computing device for extracting information from a standardized PDF report in a non-paragraph format. In one embodiment, the computing device includes an electronic processor, and a memory. The memory includes program instructions that, when executed by the electronic processor, cause the electronic processor to receive a standardized PDF report and a configuration file, determine X coordinates and Y coordinates of bounding boxes associated with one or more text-based keys, determine one or more words in the standardized PDF report that share the Y coordinates of the bounding boxes associated with a first text-based key, sort the one or more words in the standardized PDF report that share the Y coordinates of the bounding boxes based on respective X coordinates, determine a single word that is directly adjacent to the first text-based key, and control a display to display the single word.
1. A computing device comprising:
an electronic processor; and
a memory coupled to the electronic processor, the memory including program instructions that, when executed by the electronic processor, cause the electronic processor to
receive a standardized PDF (portable document format) report that is in a non-paragraph format and a configuration file including one or more values that correspond to one or more text-based keys in the standardized PDF report,
determine X coordinates and Y coordinates of bounding boxes associated with the one or more text-based keys, the X coordinates associated with an X-direction and the Y coordinates associated with a Y-direction,
determine one or more words in the standardized PDF report that share the Y coordinates of the bounding boxes associated with a first text-based key of the one or more text-based keys,
sort the one or more words in the standardized PDF report that share the Y coordinates of the bounding boxes associated with the first text-based key based on respective X coordinates in the X-direction,
determine a single word from the one or more words that is directly adjacent to the first text-based key, and
control a display to display the single word that is directly adjacent to the first text-based key,
wherein, to control the display to display the single word that is directly adjacent to the first text-based key, the program instructions, when executed by the electronic processor, further cause the electronic processor to generate a graphical user interface to display the single word that is directly adjacent to the first text-based key.
2. The computing device of claim 1 , wherein the program instructions that, when executed by the electronic processor, further cause the electronic processor to
determine a second one or more words in the standardized PDF report that share the Y coordinates of the bounding boxes associated with a second text-based key of the one or more text-based keys, wherein the second text-based key is different than the first text-based key,
sort the second one or more words in the standardized PDF report that share the Y coordinates of the bounding boxes associated with the second text-based key based on respective X coordinates in the X-direction,
determine a single word from the second one or more words that is directly adjacent to the second text-based key, and
control the display to display the single word that is directly adjacent to the first text-based key and the single word from the second one or more words that is directly adjacent to the second text-based key.
3. The computing device of claim 1 , further comprising the display.
4. The computing device of claim 1 , wherein the graphical user interface is a web interface.
5. A computing device comprising:
an electronic processor; and
a memory coupled to the electronic processor, the memory including program instructions that, when executed by the electronic processor, cause the electronic processor to
receive a standardized PDF (portable document format) report that is in a non-paragraph format and a configuration file including one or more values that correspond to one or more text-based keys in the standardized PDF report,
determine X coordinates and Y coordinates of bounding boxes associated with the one or more text-based keys, the X coordinates associated with an X-direction and the Y coordinates associated with a Y-direction,
determine one or more words in the standardized PDF report that share the Y coordinates of the bounding boxes associated with a first text-based key of the one or more text-based keys,
sort the one or more words in the standardized PDF report that share the Y coordinates of the bounding boxes associated with the first text-based key based on respective X coordinates in the X-direction,
determine a single word from the one or more words that is directly adjacent to the first text-based key, and
control a display to display the single word that is directly adjacent to the first text-based key,
wherein the memory further includes a database, and
wherein the program instructions, when executed by the electronic processor, further cause the electronic processor to store the single word that is directly adjacent to the first text-based key in the database.
6. The computing device of claim 5 , wherein the program instructions, when executed by the electronic processor, further cause the electronic processor to store the standardized PDF report, the configuration file, the single word that is directly adjacent to the first text-based key, or a combination thereof in the database.
7. A system comprising:
a display device; and
a server communicatively connected to the display device, the server including
an electronic processor; and
a memory coupled to the electronic processor, the memory including program instructions that, when executed by the electronic processor, cause the electronic processor to
receive a standardized PDF (portable document format) report that is in a non-paragraph format and a configuration file including one or more values that correspond to one or more text-based keys in the standardized PDF report,
determine X coordinates and Y coordinates of bounding boxes associated with the one or more text-based keys, the X coordinates associated with an X-direction and the Y coordinates associated with a Y-direction,
determine one or more words in the standardized PDF report that share the Y coordinates of the bounding boxes associated with a first text-based key of the one or more text-based keys,
sort the one or more words in the standardized PDF report that share the Y coordinates of the bounding boxes associated with the first text-based key based on respective X coordinates in the X-direction,
determine a single word from the one or more words that is directly adjacent to the first text-based key, and
control a display to display the single word that is directly adjacent to the first text-based key,
wherein, to control the display to display the single word that is directly adjacent to the first text-based key, the program instructions that, when executed by the electronic processor, further cause the electronic processor to generate a graphical user interface to display the single word that is directly adjacent to the first text-based key.
8. The system of claim 7 , wherein the program instructions that, when executed by the electronic processor, further cause the electronic processor to
determine a second one or more words in the standardized PDF report that share the Y coordinates of the bounding boxes associated with a second text-based key of the one or more text-based keys, wherein the second text-based key is different than the first text-based key,
sort the second one or more words in the standardized PDF report that share the Y coordinates of the bounding boxes associated with the second text-based key based on respective X coordinates in the X-direction,
determine a single word from the second one or more words that is directly adjacent to the second text-based key, and
control the display to display the single word that is directly adjacent to the first text-based key and the single word from the second one or more words that is directly adjacent to the second text-based key.
9. The system of claim 7 , wherein the graphical user interface is a web interface.
10. A system comprising:
a display device; and
a server communicatively connected to the display device, the server including
an electronic processor; and
a memory coupled to the electronic processor, the memory including program instructions that, when executed by the electronic processor, cause the electronic processor to
receive a standardized PDF (portable document format) report that is in a non-paragraph format and a configuration file including one or more values that correspond to one or more text-based keys in the standardized PDF report,
determine X coordinates and Y coordinates of bounding boxes associated with the one or more text-based keys, the X coordinates associated with an X-direction and the Y coordinates associated with a Y-direction,
determine one or more words in the standardized PDF report that share the Y coordinates of the bounding boxes associated with a first text-based key of the one or more text-based keys,
sort the one or more words in the standardized PDF report that share the Y coordinates of the bounding boxes associated with the first text-based key based on respective X coordinates in the X-direction,
determine a single word from the one or more words that is directly adjacent to the first text-based key, and
control a display to display the single word that is directly adjacent to the first text-based key,
wherein the memory further includes a database, and
wherein the program instructions that, when executed by the electronic processor, further cause the electronic processor to store the single word that is directly adjacent to the first text-based key in the database.
11. The system of claim 10 , wherein the program instructions that, when executed by the electronic processor, further cause the electronic processor to store the standardized PDF report, the configuration file, the single word that is directly adjacent to the first text-based key, or a combination thereof in the database.
12. A non-transitory computer-readable medium comprising instructions that, when executed by an electronic processor, cause the electronic processor to perform a set of operations comprising:
receiving a standardized PDF (portable document format) report that is in a non-paragraph format and a configuration file including one or more values that correspond to one or more text-based keys in the standardized PDF report;
determining X coordinates and Y coordinates of bounding boxes associated with the one or more text-based keys, the X coordinates associated with an X-direction and the Y coordinates associated with a Y-direction;
determining one or more words in the standardized PDF report that share the Y coordinates of the bounding boxes associated with a first text-based key of the one or more text-based keys;
sorting the one or more words in the standardized PDF report that share the Y coordinates of the bounding boxes associated with the first text-based key based on respective X coordinates in the X-direction;
determining a single word from the one or more words that is directly adjacent to the first text-based key; and
controlling a display to display the single word that is directly adjacent to the first text-based key,
wherein controlling the display to display the single word that is directly adjacent to the first text-based key further includes generating a graphical user interface to display the single word that is directly adjacent to the first text-based key.
13. The non-transitory computer-readable medium of claim 12 , wherein the set of operations further includes
determining a second one or more words in the standardized PDF report that share the Y coordinates of the bounding boxes associated with a second text-based key of the one or more text-based keys, wherein the second text-based key is different than the first text-based key;
sorting the second one or more words in the standardized PDF report that share the Y coordinates of the bounding boxes associated with the second text-based key based on respective X coordinates in the X-direction;
determining a single word from the second one or more words that is directly adjacent to the second text-based key; and
controlling the display to display the single word that is directly adjacent to the first text-based key and the single word from the second one or more words that is directly adjacent to the second text-based key.
14. The non-transitory computer-readable medium of claim 13 , wherein controlling the display to display the single word that is directly adjacent to the first text-based key and the single word from the second one or more words that is directly adjacent to the second text-based key further includes generating the graphical user interface to display the single word that is directly adjacent to the first text-based key and the single word that is directly adjacent to the second text-based key.
15. The non-transitory computer-readable medium of claim 14 , wherein the graphical user interface is a web interface.
16. A non-transitory computer-readable medium comprising instructions that, when executed by an electronic processor, cause the electronic processor to perform a set of operations comprising:
receiving a standardized PDF (portable document format) report that is in a non-paragraph format and a configuration file including one or more values that correspond to one or more text-based keys in the standardized PDF report;
determining X coordinates and Y coordinates of bounding boxes associated with the one or more text-based keys, the X coordinates associated with an X-direction and the Y coordinates associated with a Y-direction;
determining one or more words in the standardized PDF report that share the Y coordinates of the bounding boxes associated with a first text-based key of the one or more text-based keys;
sorting the one or more words in the standardized PDF report that share the Y coordinates of the bounding boxes associated with the first text-based key based on respective X coordinates in the X-direction;
determining a single word from the one or more words that is directly adjacent to the first text-based key;
controlling a display to display the single word that is directly adjacent to the first text-based key; and
storing the single word that is directly adjacent to the first text-based key in a database.
17. A method for extracting information from a standardized PDF (portable document format) report that is in a non-paragraph format, the method comprising:
receiving, with an electronic processor, the standardized PDF report that is in the non-paragraph format and a configuration file including one or more values that correspond to one or more text-based keys in the standardized PDF report;
determining, with the electronic processor, X coordinates and Y coordinates of bounding boxes associated with the one or more text-based keys, the X coordinates associated with an X-direction and the Y coordinates associated with a Y-direction;
determining, with the electronic processor, one or more words in the standardized PDF report that share the Y coordinates of the bounding boxes associated with a first text-based key of the one or more text-based keys;
sorting, with the electronic processor, the one or more words in the standardized PDF report that share the Y coordinates of the bounding boxes associated with the first text-based key based on respective X coordinates in the X-direction;
determining, with the electronic processor, a single word from the one or more words that is directly adjacent to the first text-based key; and
controlling, with the electronic processor, a display to display the single word that is directly adjacent to the first text-based key,
wherein controlling the display to display the single word that is directly adjacent to the first text-based key further includes generating a graphical user interface to display the single word that is directly adjacent to the first text-based key.
18. The method of claim 17 , further comprising:
determining, with the electronic processor, a second one or more words in the standardized PDF report that share the Y coordinates of the bounding boxes associated with a second text-based key of the one or more text-based keys, wherein the second text-based key is different than the first text-based key;
sorting, with the electronic processor, the second one or more words in the standardized PDF report that share the Y coordinates of the bounding boxes associated with the second text-based key based on respective X coordinates in the X-direction;
determining, with the electronic processor, a single word from the second one or more words that is directly adjacent to the second text-based key; and
controlling the display to display the single word that is directly adjacent to the first text-based key and the single word from the second one or more words that is directly adjacent to the second text-based key.
19. The method of claim 18 , wherein the graphical user interface is a web interface.
20. A method for extracting information from a standardized PDF (portable document format) report that is in a non-paragraph format, the method comprising:
receiving, with an electronic processor, the standardized PDF report that is in the non-paragraph format and a configuration file including one or more values that correspond to one or more text-based keys in the standardized PDF report;
determining, with the electronic processor, X coordinates and Y coordinates of bounding boxes associated with the one or more text-based keys, the X coordinates associated with an X-direction and the Y coordinates associated with a Y-direction;
determining, with the electronic processor, one or more words in the standardized PDF report that share the Y coordinates of the bounding boxes associated with a first text-based key of the one or more text-based keys;
sorting, with the electronic processor, the one or more words in the standardized PDF report that share the Y coordinates of the bounding boxes associated with the first text-based key based on respective X coordinates in the X-direction;
determining, with the electronic processor, a single word from the one or more words that is directly adjacent to the first text-based key;
controlling, with the electronic processor, a display to display the single word that is directly adjacent to the first text-based key; and
storing the single word that is directly adjacent to the first text-based key in a database.