Code: Select all

// Define percentage of rows to be dropped. Integer Number between 0 and 100.
var g_nDropPercentage = 10;

// Call as function:
dropRandomRows();

function dropRandomRows() {
  // is is a csv file - if not quit this function
  if(! UltraEdit.activeDocument.isExt("csv")) {
    return;
  }

  // Go to bottom of active document
  UltraEdit.activeDocument.bottom();

  // Ensure last line has line ending
  if (UltraEdit.activeDocument.isColNumGt(1)) {
    UltraEdit.activeDocument.insertLine();
    if (UltraEdit.activeDocument.isColNumGt(1)) UltraEdit.activeDocument.deleteToStartOfLine();
    UltraEdit.activeDocument.bottom();
  }

  // Line after the last line endning is not counted, hence minus 1
  var nTotalNumberOfLines = UltraEdit.activeDocument.currentLineNum - 1;

  // Drop further action on empty files
  if(nTotalNumberOfLines < 1) {
    return;
  }

  // Calculate the number of lines to be dropped:
  var nNumberOfLinesToBeDropped = Math.floor( (nTotalNumberOfLines / 100) * g_nDropPercentage) + 1;

  // If to few lines - drop further action:
  if(nNumberOfLinesToBeDropped<1) {
    return;
  }

  // while there are still lines to be dropped - iterate:
  while(nNumberOfLinesToBeDropped>0) {
    // calculate a random line number:
    var nRandomLineNum = Math.floor( Math.random() * nTotalNumberOfLines);

    // Goto random line and delete it:
    UltraEdit.activeDocument.gotoLine(nRandomLineNum,0);
    UltraEdit.activeDocument.deleteLine();

    // Decrease total number of lines by 1:
    nTotalNumberOfLines--;

    // Decrease number of lines to be dropped by 1:
    nNumberOfLinesToBeDropped--;
  }
}