hyperlinks in a csv file

Hi jamb71,

I suppose you could read the two collumns into arrays with javascript.

This have not been tested:

var myDocument = app.documents.item(0);
var LinksA = new Array();
LinksA[0] = "Old Value 0";
LinksA[1] = "Old Value 1";
LinksA[2] = "Old Value 2";
var LinksB = new Array();
LinksB[0] = "New Value 0";
LinksB[1] = "New Value 1";
LinksB[2] = "New Value 2";

for (i=0;i<LinksA.length;i++) {
     //LnksA
     var findWhat = LinksA;
     var changeTo = LinksB;
     
     if(myDocument.hyperlinkURLDestinations.length > 0){
          for(var myCounter = myDocument.hyperlinkURLDestinations.length -1; myCounter >=0; myCounter--){
               myDestinationURL = myDocument.hyperlinkURLDestinations.item(myCounter).destinationURL;
               if(myDestinationURL.search(findWhat) != -1){
                    myDocument.hyperlinkURLDestinations.item(myCounter).destinationURL = myDestinationURL.replace(findWhat, changeTo);
               }
          }
     }
}

--

molsted