Tapatalk

Script to act as word censor - replace words in file A by words in file B in active file

Script to act as word censor - replace words in file A by words in file B in active file

2362
MasterMaster
2362

    Mar 01, 2013#1

    I need a script or macro to act as a word censor line by line in a file.

    Here is the scenario. I have a file named "censoredwords.txt", where there is one word or phrase per line, which might contain punctuation (such as an apostrophe or exclamation point). I have a second file name "replacewords.txt" where there is one word or phrase per line, which is used to replace the "censored word" on that same line number from the "censoredwords.txt" file.

    Then I have a source file. The source file is a text file that needs a script to search for each line item contained in the "censoredwords.txt" file, and replace all such occurrences from the corresponding line number in the "replacewords.txt" file.

    Here is the catch, it should only apply changes to lines where there is an "=" character, and only change what is to the right of the first "=" character it finds, but all occurrences of each word to the right of that character should be changed.

    I'm afraid my mind is mud this week. I'm averaging less than 3 hours sleep per night taking care of my teething baby. Anyone that can provide a script that can do this, I would be very grateful.

    Sample files?
    censoredwords.txt

    Code: Select all

    gorgon
    wraith
    tarantula
    
    replacewords.txt

    Code: Select all

    monster
    ghost
    spider
    
    source file

    Code: Select all

    $txt['monster'] = 'The gorgon ate the statue.';
    $txt['ghost'] = 'The wraith passed through the wall to attack the gorgon with a gorgon eating tarantula.';
    $txt['spider'] = 'The tarantula laid an egg containing tarantula larvae inside the gorgon, which ate the gorgon from the inside out. This made the ghost happy.';
    

    6,685587
    Grand MasterGrand Master
    6,685587

      Mar 02, 2013#2

      It was a honor to write this little script for you. It is not tested completely, but it works for the example.

      Please note that the script as is
      1. works only for small files with some KB or a few MB;
      2. counts only the modified lines and outputs this number and not the number of replaced words/phrases;
      3. replaces entire file content when a line is modified instead of just the modified lines and therefore the line change indicator marks all lines as modified;
      4. searches for the censored words/phrases case-sensitive and replaces them with the case-sensitive words/phrases.
      As the words list most likely contain the words/phrases only in lower case and the source file could contain the words/phrases also with first letter in upper case because of being at the beginning of a sentence, the script duplicates both word lists and changes the case of the first character in word/phrase in the two additional lists depending on the case of the first character of the censored word/phrase. Every text after the equal sign is checked with both lists. This should result in a correct output for the words/phrases at beginning of a sentence too.

      If the source file is large a completely different method would be better which runs regular expression Replace All commands from top of source file for every word/phrase pair in the two files. The different method is most likely slower and produces lots of undo history entries if undo feature is not disabled because large file loaded without a temporary file, but the line change indicator would work with this approach.

      Code: Select all

      // Fixed full name of the 2 files with the words.
      var sCensoredWordsFile = "C:\\Temp\\censoredwords.txt";
      var sReplaceWordsFile  = "C:\\Temp\\replacewords.txt";
      var sLineTerminator = "\r\n";
      
      // =========================================================================
      
      function GetFileIndex (sFullNameOfFile) {
      
         // Is the passed value not a string because simply nothing passed?
         if (typeof(sFullNameOfFile) != "string") {
            // With UltraEdit v16.00 and later there is a property which holds active document index.
            if (typeof(UltraEdit.activeDocumentIdx) == "number") return UltraEdit.activeDocumentIdx;
            sFullNameOfFile = UltraEdit.activeDocument.path;
         }
         // It is a string. Is the string empty?
         else if (!sFullNameOfFile.length) {
            if (typeof(UltraEdit.activeDocumentIdx) == "number") return UltraEdit.activeDocumentIdx;
            sFullNameOfFile = UltraEdit.activeDocument.path;
         }
         // Windows file systems are not case sensitive. So best make all file
         // names lowercase before comparing the name of the file to search
         // for with the names of the already opened files. Users of UEX should
         // use a case sensitive file name comparison and therefore don't need
         // toLowerCase() here and in the following loop.
         var sFileNameToCompare = sFullNameOfFile.toLowerCase();
      
         // Compare the name of the file to search for with the (lowercase) file
         // names of all already opened files. Return the document index of the
         // file already opened when found.
         for (var nDocIndex = 0; nDocIndex < UltraEdit.document.length; nDocIndex++) {
            if (UltraEdit.document[nDocIndex].path.toLowerCase() == sFileNameToCompare) {
               return nDocIndex;
            }
         }
         return -1; // This file is not opened.
      }
      
      // =========================================================================
      
      function sortByStringLength (sFirst,sSecond)
      {
         if (sFirst[1] > sSecond[1]) return -1;
         else if (sFirst[1] < sSecond[1]) return 1;
         return 0;
      }
      
      // =========================================================================
      
      if (UltraEdit.document.length > 0)  // Is any file opened?
      {
         // Define environment for this script.
         UltraEdit.insertMode();
         UltraEdit.columnModeOff();
         UltraEdit.activeDocument.hexOff();
      
         // Determine document index of active file - the source file.
         var nSourceDocIndex = GetFileIndex();
         var asCensoredUnsorted;
         var asReplaceUnsorted;
      
         // Load the censored words.
         var nWordsDocIndex = GetFileIndex(sCensoredWordsFile);
         if (nWordsDocIndex < 0)
         {  // File with the censored words not yet opened.
            UltraEdit.open(sCensoredWordsFile);
            UltraEdit.activeDocument.selectAll();
            asCensoredUnsorted = UltraEdit.activeDocument.selection.split(sLineTerminator);
            UltraEdit.closeFile(UltraEdit.activeDocument.path,2);
            UltraEdit.document[nSourceDocIndex].setActive();
         }
         else
         {  // File with the censored words already opened.
            UltraEdit.document[nWordsDocIndex].selectAll();
            asCensoredUnsorted = UltraEdit.document[nWordsDocIndex].selection.split(sLineTerminator);
            UltraEdit.document[nWordsDocIndex].top();
         }
         // Remove last string from array if it is an empty string because
         // the last line of the file has also a DOS line termination.
         if (!asCensoredUnsorted[asCensoredUnsorted.length-1].length) asCensoredUnsorted.pop();
      
         // Load the replace words.
         nWordsDocIndex = GetFileIndex(sReplaceWordsFile);
         if (nWordsDocIndex < 0)
         {  // File with the replace words not yet opened.
            UltraEdit.open(sReplaceWordsFile);
            UltraEdit.activeDocument.selectAll();
            asReplaceUnsorted = UltraEdit.activeDocument.selection.split(sLineTerminator);
            UltraEdit.closeFile(UltraEdit.activeDocument.path,2);
            UltraEdit.document[nSourceDocIndex].setActive();
         }
         else
         {  // File with the replace words already opened.
            UltraEdit.document[nWordsDocIndex].selectAll();
            asReplaceUnsorted = UltraEdit.document[nWordsDocIndex].selection.split(sLineTerminator);
            UltraEdit.document[nWordsDocIndex].top();
         }
         if (!asReplaceUnsorted[asReplaceUnsorted.length-1].length) asReplaceUnsorted.pop();
      
         // For script stability take the lower value of words count.
         // Actually both word lists should contain same number of strings.
         var nWordCount = asCensoredUnsorted.length;
         if (asReplaceUnsorted.length < asCensoredUnsorted.length)
         {
            // Remove all censored words from array for which no replace word exists.
            var nTooManyCensoredWords = nWordCount - asReplaceUnsorted.length;
            asCensoredUnsorted.splice(asReplaceUnsorted.length,nTooManyCensoredWords);
            nWordCount = asReplaceUnsorted.length;
         }
         else if (asReplaceUnsorted.length > asCensoredUnsorted.length)
         {
            // Remove all replace words from array for which no censored word exists.
            var nTooManyReplaceWords = asReplaceUnsorted.length - nWordCount;
            asReplaceUnsorted.splice(nWordCount,nTooManyReplaceWords);
         }
      
         // Build an array with index number and string length of censored
         // word/phrase in a subarray for every censored word/phrase.
         var anSortIndex = new Array();
         for (var nWordIndex = 0; nWordIndex < nWordCount; nWordIndex++)
         {
            anSortIndex[nWordIndex] = new Array(nWordIndex,asCensoredUnsorted[nWordIndex].length);
         }
         // Sort this number array based on the string length values. This is
         // for sorting the censored words/phrases from longest to shortest to
         // avoid a replace of a shorther substring first before replacing the
         // longer string containing the substring too and apply the same sort
         // also on the list or replace words as a censored and a replace word
         // build a pair.
         anSortIndex.sort(sortByStringLength);
         
         // There could be words to replace at beginning of a sentence in
         // upper case and elsewhere in lower case. The lists most likely
         // contain the words/phrases only in one case (lower case).
         // So better create duplicates of these two lists with first character
         // changed in case to find and replace also words starting with an
         // upper case letter because of being at beginning of a sentence.
         // At the same time 2 more arrays are created for censored and
         // replace words/phrases completely converted to upper case.
      
         var asCensoredWords = new Array(nWordCount);
         var asReplaceWords  = new Array(nWordCount);
         var asCaseCensoredWords = new Array(nWordCount);
         var asCaseReplaceWords  = new Array(nWordCount);
         var asUpperCensoredWords = new Array(nWordCount);
         var asUpperReplaceWords  = new Array(nWordCount);
      
         for (var nWordIndex = 0; nWordIndex < nWordCount; nWordIndex++)
         {
            // Build the censored and replace words/phrase list based on string
            // length of censored words/phrases from longest to shortest.
            asCensoredWords[nWordIndex] = asCensoredUnsorted[anSortIndex[nWordIndex][0]];
            asReplaceWords[nWordIndex]  = asReplaceUnsorted[anSortIndex[nWordIndex][0]];
      
            // Find out if first character of censored word/phrase
            // is a lower or upper case character.
            var sFirstChar = asCensoredWords[nWordIndex].substr(0,1);
            var sUpperChar = sFirstChar.toLocaleUpperCase();
            // Is the first character in censored word/phrase lower case?
            if (sUpperChar != sFirstChar)
            {
               // Create the strings in the second arrays with first character in upper case.
               asCaseCensoredWords[nWordIndex] = sUpperChar + asCensoredWords[nWordIndex].substr(1);
               asCaseReplaceWords[nWordIndex]  = asReplaceWords[nWordIndex].substr(0,1).toLocaleUpperCase() +
                                                 asReplaceWords[nWordIndex].substr(1);
            }
            else  // The first character is already in upper case.
            {
               // Create the strings in the second arrays with first character in lower case.
               asCaseCensoredWords[nWordIndex] = sFirstChar.toLocaleLowerCase() + asCensoredWords[nWordIndex].substr(1);
               asCaseReplaceWords[nWordIndex]  = asReplaceWords[nWordIndex].substr(0,1).toLocaleLowerCase() +
                                                 asReplaceWords[nWordIndex].substr(1);
            }
            asUpperCensoredWords[nWordIndex] = asCensoredWords[nWordIndex].toLocaleUpperCase();
            asUpperReplaceWords[nWordIndex]  = asReplaceWords[nWordIndex].toLocaleUpperCase();
         }
      
         // Get all lines of source file into an array.
         UltraEdit.activeDocument.selectAll();
         var asSourceLines = UltraEdit.activeDocument.selection.split(sLineTerminator);
      
         var nLineModCount = 0;
         // Process all lines with an equal sign.
         for (var nLineNum = 0; nLineNum < asSourceLines.length; nLineNum++)
         {
            // Get character position of equal sign in current line.
            var nEqualSignPos = asSourceLines[nLineNum].indexOf('=');
            // If the line does not contain an equal sign, continue with next line.
            if (nEqualSignPos < 0) continue;
            // Get the text after the equal sign.
            var sTextToCheck = asSourceLines[nLineNum].substr(++nEqualSignPos);
            var sCheckedText = sTextToCheck;
            // Replace case-sensitive all strings in the censored word list
            // by the corresponding word/phrase in the replace word list.
            for (var nWordIndex = 0; nWordIndex < nWordCount; nWordIndex++)
            {
               // Search and replace the word/phrase as written in the words lists.
      //         var rRegSearch = new RegExp("\\b"+asCensoredWords[nWordIndex]+"\\b","g");
               var rRegSearch = new RegExp(asCensoredWords[nWordIndex],"g");
               sCheckedText = sCheckedText.replace(rRegSearch,asReplaceWords[nWordIndex]);
               // Search and replace the word/phrase with first character changed in case.
      //         rRegSearch = new RegExp("\\b"+asCaseCensoredWords[nWordIndex]+"\\b","g");
               rRegSearch = new RegExp(asCaseCensoredWords[nWordIndex],"g");
               sCheckedText = sCheckedText.replace(rRegSearch,asCaseReplaceWords[nWordIndex]);
               // Search and replace the word/phrase with all letters in upper case.
      //         rRegSearch = new RegExp("\\b"+asUpperCensoredWords[nWordIndex]+"\\b","g");
               rRegSearch = new RegExp(asUpperCensoredWords[nWordIndex],"g");
               sCheckedText = sCheckedText.replace(rRegSearch,asUpperReplaceWords[nWordIndex]);
            }
            // Was indeed anything replaced in the text?
            if (sCheckedText != sTextToCheck)
            {
               nLineModCount++;
               // Concatenate fixed string up to equal sign with modified text.
               asSourceLines[nLineNum] = asSourceLines[nLineNum].substr(0,nEqualSignPos) + sCheckedText;
            }
         }
      
         if (nLineModCount)   // Was any line modified?
         {
            // Use user clipboard 9 for writing all lines back to the file overwriting
            // the selection as this is faster than using the document write command.
            UltraEdit.selectClipboard(9);
            UltraEdit.clipboardContent = asSourceLines.join(sLineTerminator);
            UltraEdit.activeDocument.paste();
            UltraEdit.clearClipboard();
            UltraEdit.selectClipboard(0);
         }
         // Cancel selection and move caret to top of source file.
         UltraEdit.activeDocument.top();
         // Let the script user know how many lines were modified.
         UltraEdit.messageBox(nLineModCount.toString() + " line" + (nLineModCount!=1 ? "s" : "") + " modified!");
      }
      Edited on 2013-03-03:
      Script updated to sort the two arrays with the words/phrases based on length of the censored words/phrases. That was more tricky as I first thought. I had several ideas and decided to use the one above as it should be fast.

      Further two more arrays are added and applied with all letters in upper case.

      2362
      MasterMaster
      2362

        Mar 02, 2013#3

        Mofi,

        Thank you so much. Since I also have some instances where a word is in all caps, I also need it to check for all caps occurrences as well. I had originally planned to copy and convert the list to Capitalized and all caps, but your script saves me a lot on that one.

        If you could add the ability to check against all caps in the same manner that you did the first character capitalized, it would be awesome.

        One error I'm getting... if the string in the censoredwords.txt file is a substring source file, it changes it, and it should only change for "whole words matched only".

        For example, the word "to" in censoredwords.txt becoming "t\'" in replacewords.txt is changing the word "topic" in the source file to "t\'pic" when it should not touch that word.

        6,685587
        Grand MasterGrand Master
        6,685587

          Mar 03, 2013#4

          Script updated according to the 2 new requirements.

          Please note that the script as is in version 2 does still not avoid a replace in an alreay applied replace word/phrase. So if there is for example

          censoredwords.txt
          subject
          to

          replacewords.txt
          topic
          two

          and the source file contains subject, the result will be twopic.

          Rewriting the script for not replacing something in a text which was already taken before from the replace words list is very tricky. I have already some ideas how to do this, but not yet the time to experiment with those ideas.

          For example using in the regular expression always \b (word boundary) would make it easy to avoid that, but might work only if all words/phrases start and end with a letter. I added this variant with commented lines. Hm, if \b can be used, it would be better to surround the censored words with "\\b" already on creation of the as*CensoredWords arrays to make the script faster.

          2362
          MasterMaster
          2362

            Mar 03, 2013#5

            Thanks Mofi. I'm traveling right now, so I'll test it when I return home.

            I'm not sure why "topic" would be changed to "twopic", unless the issue of "whole words only" isn't resolved. It should only change the word "to" to "two" if "to" is the whole word, preceded and followed by a word delimiter.