Icon

78914 - Extract data from PDF

Forum Posthttps://forum.knime.com/t/pdf-table-to-excel/78914ChallengeExtract data from a PDF as a structure table. NotesInstead of one complex RegEx use individual splits,followign "Divide et impera" principle.If more complex strings are present, like theproduct description, split apart teh easy maatchesfirst following the same principle aas before. ReadContentNode 2SplitLine Item NoRemoveLine Item NoRemoveProduct CodeSplitProduct CodeRemove(Per Unit) Bid PriceSplit(Per Unit) Bid PriceRemovePrice End DateSplitPrice End DateRemovePrice Start DateSplitPrice Start DateSplit Results toProduct DescriptionSort ColumnNamesDefioneColumn OrderNode 36Fix Dayin Dates Tika ParserURL Input Table Creator String Replacer String Replacer String Replacer String Replacer String Replacer String Replacer String Replacer String Replacer String Replacer String Replacer Column Rename(Regex) ReferenceColumn Resorter Table Creator String to Date&Time String Manipulation(Multi Column) Manage Line Breaks Determine Starand End of Data Clean upunwanted Data Split multipletables into rows Split by Line Break intoindividual data items Sanitize Data Forum Posthttps://forum.knime.com/t/pdf-table-to-excel/78914ChallengeExtract data from a PDF as a structure table. NotesInstead of one complex RegEx use individual splits,followign "Divide et impera" principle.If more complex strings are present, like theproduct description, split apart teh easy maatchesfirst following the same principle aas before. ReadContentNode 2SplitLine Item NoRemoveLine Item NoRemoveProduct CodeSplitProduct CodeRemove(Per Unit) Bid PriceSplit(Per Unit) Bid PriceRemovePrice End DateSplitPrice End DateRemovePrice Start DateSplitPrice Start DateSplit Results toProduct DescriptionSort ColumnNamesDefioneColumn OrderNode 36Fix Dayin Dates Tika ParserURL Input Table Creator String Replacer String Replacer String Replacer String Replacer String Replacer String Replacer String Replacer String Replacer String Replacer String Replacer Column Rename(Regex) ReferenceColumn Resorter Table Creator String to Date&Time String Manipulation(Multi Column) Manage Line Breaks Determine Starand End of Data Clean upunwanted Data Split multipletables into rows Split by Line Break intoindividual data items Sanitize Data

Nodes

Extensions

Links

Download

To use this workflow in KNIME, download it from the below URL and open it in KNIME:

Download Workflow
Created by: Mike Wiegand
Created at: 2024-05-04
On NodePit since: 2024-05-05
Last update: 2024-11-23
Created with KNIME version: v5.2.3

Deploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.

Try NodePit Runner!