These forums were permanently set to read-only mode on July 20, 2022. From that day onwards, no new posting or comment is allowed on the site, but the historical content remains intact and searchable.

A new location for posting questions about PlanetPress Suite is now available:

OL Learn - PlanetPress Classic (opens in new tab)

Topic Options
#57877 - 02/19/21 12:49 PM Merge PDF files help
Tom@ECI Offline
OL Newbie

Registered: 04/20/10
Posts: 24
Loc: Fort Worth, Tx
I have invoices being saved to c:\invoices\ with the delivery route followed by invoice number as the file name. Example "EAST_123450-0.pdf"

At the end of the day, I am using the Merge PDF plugin to combine these together into one file. However, I need a separate file for each route. Example: "EAST.PDF" and a "WEST.PDF".

There are about a hundred different routes, so it's not really feasible for me to set up a different process for each route.

Is there a way that I can use my existing process to split these out?

#57878 - 02/19/21 03:46 PM Re: Merge PDF files help [Re: Tom@ECI]
Jean-Cédric Offline
OL Expert

Registered: 10/03/16
Posts: 681
Loc: Québec, Canada
You could setup another process that grabs all files from your c:\invoices folder.
Then you set a a script (VB or JScript...your choice) that will extract the route part of the file name (using regex) and store this into a variable.
Then it is simply a matter of outputting to a folder using the Send to Folder plugin, naming the file by the content of the variable and ticking the Concatenate files option while leaving the Separator String filed empty.
99 frigging bugs in my code
99 frigging bugs
Take one down
Code around
127 frigging bugs in my code