Splitting PDF files using list of employee numbers

Question

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

kelly_gilbert · Answer

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?