I don't know a lot about writing code so perhaps one of you can come up with a solution to this repetitive task.
I have created a 232 page catalog. All products in the catalog have either an ISBN number, product number, or UPC listed with them.
In order to create the digital, shoppable version of the catalog for our website, we are having to go through an manually put hyperlinks in for each number/product. Each product will also, obviously, have a separate URL on our website.
So with that background information, I need a script that can match the number to it's appropriate URL and make that number a hyperlink.
I'm not sure if this can somehoe be done with Data Merge, but I figured I would ask this in scripting.
If the strings are unique you should be able to find each one programmatically and make a hyperlink out of it. I've done this with a simple Filemaker database of the strings and their corresponding URLs and Applescript.