Split Pdf

[Anonymous]

Hello Team,

Scenario is I received email invoice[Multiple invoice within one pdf] from the vendor. Now we want to split pdf based on invoice and save as invoice no.

To achieve this functionality currently we are using Aquaforest Split pdf tool.

How can we split the pdf which contain multiple invoice, 3 invoice may have 4 pages, then 2 have 2 pages and another 1 have 1 page. So how to split this pdf based on invoice and save as invoice no??

Thanks,

Bansari Pandya.

[AnthonyAmador]

Hi @Anonymous 

Have you tried using the Aquaforest extracting pages by text?, I found a documentation about Aquaforest in flow I hope this can help you. 

Advanced PDF actions for Power Automate, Azure Logic Apps or PowerApps. (aquaforest.com)

[Anonymous]

@AnthonyAmador Yes but how can we pass dynamic value? do you have any idea? For the reference, want to mention here I also tried with Adobe and Encodian. 

Can you brief the process, like how can I achieve this?

Thanks,

Bansari Pandya. 

[AnthonyAmador]

@AnonymousCan I know what is the dynamic value you want to pass? 

[Anonymous]

@AnthonyAmador In my scenario, pdf contain 3 invoice, 1 invoice have 2 pages, 2nd have 3 and 3rd have 5. So how can I split this pdf?

Thanks,

Bansari Pandya

[AnthonyAmador]

Hi @Anonymous 

I did an example using Encodian hope this helps for you, first thing you should know is that our source PDF must be store somewhere, in this example I use Sharepoint, but there are many connectors that you can use in power automate. 

First thing I create my source PDF and upload it to my SharePoint tenant. 

Then I access the PDF using the SharePoint connector.

Next, I use Encodian to select the source PDF and divide it into pages. For use Encodian you have to create a Apy Key you can do that here.

In the split setting you select the desired pages, i.e. from page 1 to 3 [1-3]. But you can also select different types of division. 

And finally you have to create a new file with the new pdf, in my case I use SharePoint again.

I also create a parallels branch to make all the splits in the same flow, here is a screenshot of the complete flow.

And the final result 

Hope this can help you, any questions or comments just let me know. 

Cheers.

[Anonymous]

@AnthonyAmador Thanks for detail response. 

One question here, in split configuration instead of [1-3]page can we split it by invoice no[No of pages contain invoice no]?

Thanks,

Bansari Pandya.

[AnthonyAmador]

@Anonymous yes, I think its posible. 

In this link you can check the diferent options to split a PDF with Encodian. 

https://support.encodian.com/hc/en-gb/articles/360002953277-Split-PDF

I hope this helps. 

[Alex_Donhou]

Hi Bansari,

This is a common scenario when splitting invoices, and using the 'Split PDF by text match' is how most people split documents into separate invoices.

To split at each invoice, we use the page numbering to split on page 1 of each invoice by setting the 'Text Value Item' (or 'Text Pattern') value to "1 of". The page that contains text matching this value will be the first page on a new split in the document.

To select the PO number as output, the easiest way to achieve this is using our 'Get data from PDF' step. You can loop through the output of the split and extract values for key data, which can then be used later in the flow. An example of common data to extract is below.

Here is a short video to show how it works: Aquaforest PDF Connector video  

I hope this helps!

Kind Regards,

Alex

Note: This solution was exchanged directly between Aquaforest and the original Asker. I am posting it here to help other members find a solution to similar problems. Please consider selecting Accept it as the solution to help the other members find it more quickly.

[tliem]

I want to split a report PDF into separate PDF for each bookmark and have the resulting PDF be named the Bookmark.  How can I do this with Encodian?

Thanks

[Alex_Donhou]

Hi @tliem,

As Anthony mentioned earlier in the thread, this Encodian article online talks about their different split types, which includes a 'BookmarkLevel' option. https://support.encodian.com/hc/en-gb/articles/360002953277-Split-PDF 
I couldn't find if it was possible to name the resulting PDF after the bookmark, so you may have to raise a query with them directly.

Renaming the PDF from the bookmark is possible using the Aquaforest 'Split PDF by page' Step, so I have included an example flow below.

Here is a link to the Aquaforest Documentation, including the split step: https://www.aquaforest.com/resources/aquaforest-flow 

I hope this helps!

Kind Regards,

Alex

[salman1200]

Hi alex, 

I wanted to ask, is it possible to split PDFs based on the chapters in the table of contents, but not all of the PDFs have chapters bookmarked at table of contents, how would I reach to those chapter then.

Thank you

[Alex_Donhou]

Hi @salman1200,
 

PDF bookmarks are generated from the table of contents when PDFs are created. These bookmarks are visible when the PDF is opened in Adobe Reader, as seen in the image below. They are the only bookmarks that the "Split by Top Level Bookmark" split type will recognize.  

If you have files that you want to split in other places, there are other split type options available to choose that allow you specify the page number to split on. There is also the 'Split PDF by text match' step, which can be useful in cases where unique text identifies a place to split the file. Setting these up requires a bit more customization that depends on the input documents.

If you have a specific use-case, I would recommend sending a message to support@aquaforest.com to get help based on your documents. I hope this was useful.

Kind Regards,

Alex  

[AlexEncodian]

@Anonymous / @AnthonyAmador 

Hi, we often get asked about splitting PDFs where the number of pages per split is unknown. In this case, splitting invoices where an invoice could have 1,2 or more pages and the number of pages between invoices is inconsistent. In most cases, you can use Encodian's Split PDF by Text action to come up with a solution.

If its a simple case, you might be able to identify a Text / String split value in the document. As Alex mentioned, this could be a page number format or it could be constant value in the header of the invoice e.g. your sales tax number (if its not repeated elsewhere).

For more complex cases, you can define a split value using a regular expression. This will be more flexible and allows you to be more creative in finding a pattern in the document by which to identify new invoices. This blog article gives an example: Split a PDF by Text or Regex with Power Automate

Unfortunately, its hard to say more than this without seeing the invoices.

@salman1200 / @tliem - yes, Encodian's Split PDF action allows you to choose the Split Type "BookmarkLevel" and in the advanced section you can enable bookmark based filenames for the resulting documents.