Hi all
I am using this piece of code to split PDF files by employee numbers
Is there a way to edit this flow to match a number on the PDF with one that occurs on a list of numbers in an xlsx and split the pages when it identifies a match? The reason I ask is that I have been asked to split PDF is a large file where the employee number is not in a consistent location
So if the list was
20231322
21645548
22846546
23968465
24945331
It would look for each of those numbers in the file and pull the page out as a separate document, using number as the saved name
Dave
Question 1: are the specified IDs always present in the pdf data? Or are they just breakpoints. For example, if the data contained:
20300000
20400000
21000000
22000000
Would you need it to split between 21000000 and 22000000 even if 21645548 wasn't actually present in the pdf data? Or, would it be acceptable to put all of these in the 22846546 file if 21645548 isn't present?
Question 2: are the breakpoints truly significant, or could you determine the breakpoints based on the size of the data? In other words, is it really necessary to break on specific employees, or could you recommend, breaking the output every 1000 records, or break the output into 10 equally-sized files?