Code: Select all

/* Most left file (= document with index 0 in the document array) must be
   the file with the data. The second file (= document 1) must be the list
   file with the line numbers. Other files open are ignored. */

if (UltraEdit.document.length >= 2) {

   var sListEntry  = "";
   var nLineNumber = 1;
   var DataFile    = UltraEdit.document[0];
   var ListFile    = UltraEdit.document[1];
   var OutputFile  = UltraEdit.activeDocument;

   /* Define the working environment and open already the new file for the
      output which will become immediately the active file to avoid screen
      updates during script execution which would make the script slower. */
   UltraEdit.insertMode();
   if (typeof(UltraEdit.columnModeOff) == "function") UltraEdit.columnModeOff();
   else if (typeof(UltraEdit.activeDocument.columnModeOff) == "function") UltraEdit.activeDocument.columnModeOff();
   DataFile.hexOff();
   ListFile.hexOff();
   UltraEdit.newFile();
   ListFile.top();

   /* Verify if the last line of the data file also has a line ending.
      If this is not the case insert one and make sure that the auto
      indent feature has not added additional preceding whitespaces. */
   DataFile.bottom();
   if (DataFile.isColNumGt(1)) {
      DataFile.insertLine();
      if (DataFile.isColNumGt(1)) DataFile.deleteToStartOfLine();
   }


   /* Define once the parameters for the regular expression search with the
      UltraEdit engine used to find the line numbers in the list file. */
   UltraEdit.ueReOn();
   ListFile.findReplace.mode=0;
   ListFile.findReplace.matchCase=false;
   ListFile.findReplace.matchWord=false;
   ListFile.findReplace.regExp=true;
   ListFile.findReplace.searchAscii=false;
   ListFile.findReplace.searchDown=true;
   ListFile.findReplace.searchInColumn=false;

   /* The lines of interest could be immediately copied from the data file
      to the output file. But the script is much faster when collecting
      the lines in a user clipboard (= memory). That avoids screen updates
      and flushing the data to the temporary file. */
   UltraEdit.selectClipboard(9);
   UltraEdit.clearClipboard();

   // Find in a tab delimited list file (CSV) a number in the third column.
   while (ListFile.findReplace.find("%*^t*^t[0-9]+")) {
      /* String found with the line number of interest at end of the string.
         Get the selected search result into a string variable, extract the
         line number using a Perl regular expression and convert the line
         number from a string into an integer. */
      sListEntry = ListFile.selection;
      var aMatchResult = sListEntry.match(/\d+$/);
      nLineNumber = parseInt(aMatchResult[0],10);
      /* Go to this line in the data file, select it and append it to
         the content of user clipboard 9 when the line really exists. */
      DataFile.gotoLine(nLineNumber,1);
      /* Has the data file enough lines or is the caret now set to last
         line of the file because the line number is greater than the
         number of lines in the data file? */
      if (nLineNumber == DataFile.currentLineNum) {
         DataFile.selectLine();
         DataFile.copyAppend();
      }
   }
   OutputFile.paste();           // Write the lines into the output file.
   UltraEdit.clearClipboard();   // Clear user clipboard 9 to free memory.
   UltraEdit.selectClipboard(0); // Select again the Windows clipboard.

   /* In case the data file is read-only and the last line of the data
      file has been copied as last line into the output file and this
      line has no line termination, add the line ending now. If the
      last line of a read-only data file has no line ending and this
      line is appended to the clipboard anywhere else than at the end,
      there are 2 lines joined together in the output file. Additional
      code could be used to break the by mistake joined lines up in the
      output file, but such a code is not present here at the moment. */
   if (OutputFile.isColNumGt(1)) {
      OutputFile.insertLine();
      if (OutputFile.isColNumGt(1)) OutputFile.deleteToStartOfLine();
   }

   OutputFile.top();  // Move the cursor in all 3 files to top of the file.
   ListFile.top();
   DataFile.top();
}