🚀 go-pugleaf

I'm getting nervous. Every now and then, it looks as though it exports the complete table instead of just a cell and then reads the whole thing back (presumably into a cell). It hasn't happened very often, but I'm going to have to take a close look at the result.

Here's the actual script I used. The hierarchical nature of the sparse table I started with assured that the first two rows were populated before I started. Then, it was just a case of filling down until I found a populated cell in a row, at which point, I move on to the next row.

myPath = app.activeScript;
myParts = myPath.toString().split("/");
myParts[-1] = "movetext.txt";
myNewPath = stitchString(myParts,"/");

myTable = app.documents[0].textFrames.item('Target').tables[0];
myLim = myTable.rows.length;
myCols = myTable.columns.length;

for (var i = 2; i < myLim; i++) {
 for (var j = 0; j < myCols; j++) {
  if (myTable.rows[i].cells[j].texts.item(0).contents == "") {
   myDupMoveText(myTable.rows[i-1].cells[j].texts.item(0),myTable.rows[i].cells[j].texts.item(0));
  } else {
   break;
  }
 }
}

function myDupMoveText(mySourceText, myTargetText){
 mySourceText.exportFile(ExportFormat.taggedText, File(myNewPath));
 myTargetText.place(File(myNewPath));
}

function stitchString(theSubs,theSep) {
 var theStitched = "";
 for (var i=0; i<theSubs.length - 1; i++) {
  theStitched = theStitched + theSubs[i] + theSep;
 }
 return (theStitched + theSubs[-1]);
}

I know I don't really need the stitch function, but I lifted this from an already working script.

Dave