accessnew...@gmail.com writes: > I have two files (right now they are spreadsheets but I can export them to > any format). > > File1 has StoreID (unique) in one column and a pdf map location in the second > column. (Names not really sequenced numerically) > > 1 C:/maps/map1.pdf > 2 C:/maps/map2.pdf > 3 C:/maps/map3.pdf > 4 C:/maps/map4.pdf > > File2 has 3 columns. Column1 is the County name (unique), Column2 are the > store IDs that fall in that county separated by commas, and Column3 is > warehouse that services the store. > > County1 1,2 Warehouse1 > County2 1,3 Warehouse1 > County3 3 Warehouse4 > County4 2,4 Warehouse3 > > Is it possible to compare both files and append the maps that belong in each > county and naming it by the county_warehouse.pdf?
This will not be easy: PDF is a page layout oriented format, not a format to facilitate the processing of general structural data (such as e.g. XML). You could use a package like "pdfminer" to get at the text content of a PDF file. You will then need specialized code (developed by yourself) to reconstruct the column information. You could then use a PDF generating package such as "reportlab" to generate a new PDF file. -- https://mail.python.org/mailman/listinfo/python-list
