I have a catalog in PDF format with thousands of part numbers. I want to be able to click on each part number and be directed to a specific web page. All web pages will be different. I know how to do this ONE at a time but that would be too time consuming and not something my company would be willing to do. I have an Excel spreadsheet with the part numbers listed in one column and the URL's in one and a column of them as hyperlinks already. Is it possible for Adobe to match the part numbers from both files and merge them together?
It would be possible to create a script that reads a file, searches the document for the part number, and creates a link to a URL at the correct location. What are some examples of part numbers? This has an impact on how easy it will be to search for them. Will a part number over be broken into two or more lines?
The part numbers will all be together but most have alot of dashes and some are very long. Here are 3 examples. Alot of them are this size, some much larger but they are all together on one line.