I have a 400 page indesign brochure. It contains 3000 codes. I want to change those 3000 codes to links (existing code the word to click on - not the view of full url). I have a csv file with all codes (col 1) and full http link (col 2). Anyone help me with a find and replace? I have CS5.5 (very poor see) - my knowledge is pretty poor as I have not used the program for a few years. I would appreciate any help.
Take a look here Re: FindChangebyList with strings of text? I think #12 is what you want.
You might need to sort the order of the excel list according to the length of the word from longest to shortest.
To do that in cell C1 type =LEN(A1)
Copy that to the whole column apply the sort to the table from largest to smallest and then erase the whole column C save the file and it's ready for the script.
I would have written the script differently now as my skills have improved significantly, adding a sort function in the script would be very easy but I'm very busy now.
Forget what I wrote about sorting the length order, I see that I have search for whole words in the script which would deal with most cases by far