Hi friends. I would like some help to do a simple task. (I think) I want to read some PDFs and extract to excel only two information. I’ll explain into prints. First I have two PDFs (in truth, I have 800) and I want only those two information concatenated into a single line, like below, separated by underscore: CNPJ: 43.708.379/0003-63_Referência: 11/2022 (then replace / to another character for rename the file) [image] I’m using Tika Parse, but all PDF information are in only 1 row. Until now, I only did this: [image] [image] How can I extract those informations? To complicate more, my real goal is: Extract those two information Concatenate into one row Bring the original name of the file (I already did) Copy the original file into another folder but with the new corresponding name (concatenated) The original name is: [image] My goal is: [image] If I reach the 2) item, I will extract to excel file the results, then uses PowerAutomate to rename the files. With only two columns, the original name and new name I could ( I found a youtube video) Cheers from Brazil ReadingPDF.knwf (66.8 KB)

Hello @Felipereis50 @mlauber71 The workflow now achieves the Copy_Rename function suported only with KNIME based nodes. It is supported with ‘Transfer Files (Table)’ node, summing up @mlauber71 's suggestions. [image] [image] Data Wrangling _ Reading and Transfering PDF Files – gonhaddock https://forum.knime.com/t/pdf-extract-text-plus-export-to-excel/63074 The current workflow status covers on how to complete ‘Copy and Rename files’ function in 3 approaches for preferences: KNIME Based nodes, supported with Transfer Files (Table). R Snippet, code Python Script, code I feel the challenge to be completed now. BR

PDF - Extract Text plus export to Excel

KNIME Analytics Platform

mlauber71 March 5, 2023, 12:15pm 2

@Felipereis50 I might be able to take a look at your example later. In the meantime I could point you to this solution using Rstats to extract text from a PDF and search for a special term:

2 Likes