Community
    • Login

    How to find and replace unrecognizable characters in multiple files of a folder with the correct character using Notepad ++?

    Scheduled Pinned Locked Moved Help wanted · · · – – – · · ·
    26 Posts 5 Posters 59.6k Views
    Loading More Posts
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • PeterJonesP
      PeterJones @Ramanand Jhingade
      last edited by

      @Ramanand-Jhingade ,

      If you end up going down the route of non-Notepad++ solutions (remembering that here is not the right place to ask questions if you do), @Vasile-Caraus has posted a couple of non-Notepad++ tools that might be able to do the search-and-replace in the way that you want, the tools listed in these two posts. The second tool which he mentioned, grepWin, has been recommended by other users on the forum as well, especially in circumstances when Notepad++'s find-in-files wasn’t properly handling encoding-detection.

      Vasile showed it working for the bytes � (which is the UTF-encoding for �) because that was the focus of that previous discussion. But it will likely also work if you wanted to replace \x93 with “ and \x94 with ” – and might be easier for you to figure out than iconv or command-line grep.

      Given your requirements, grepWin may be the best tool for you for this particular smart-quote problem. (if you have grepWin questions, you will need to find a grepWin forum or other generic help site, because the Notepad++ Community is focused on Notepad++)

      Ramanand JhingadeR 1 Reply Last reply Reply Quote 1
      • Ramanand JhingadeR
        Ramanand Jhingade @PeterJones
        last edited by Ramanand Jhingade

        @PeterJones I finally found a solution here: how-to-find-non-ascii-unprintable-characters-using-notepad-plus-plus
        We have to select the Regular expression mode and search/find with this code: [\x00-\x08\x0B\x0C\x0E-\x1F\x7F-\x9F]
        I will do the replacements one by one instead of using “Replace all”

        Ramanand JhingadeR PeterJonesP 4 Replies Last reply Reply Quote 1
        • Ramanand JhingadeR
          Ramanand Jhingade @Ramanand Jhingade
          last edited by Ramanand Jhingade

          @Ramanand-Jhingade The

          Find All
          

          is making Notepad++ to stop working and close if I use the above code. Any suggestions to avoid that?

          1 Reply Last reply Reply Quote 0
          • PeterJonesP
            PeterJones @Ramanand Jhingade
            last edited by

            @Ramanand-Jhingade ,

            Find All is making Notepad++ to stop working and close if I use the above code.

            Which Find All do you mean? Do you mean the Find > Find All in Current Document, Find > Find All in Opened Documents, or Find in Files > Find All ?

            Please note that the Find in Files adds another level of confusion, because Notepad++ is trying to figure out the encoding on each file individually, and depending on the bytes in the file and your settings (as described above), it might think some are UTF-8 and others are ANSI or might pick a strange character-set value. The Find in Files isn’t great with non-ASCII characters, unfortunately. There are bug reports / feature requests, but they are taking time to get worked out.

            I suggest doing one file at a time for now.

            Ramanand JhingadeR 1 Reply Last reply Reply Quote 0
            • Ramanand JhingadeR
              Ramanand Jhingade @PeterJones
              last edited by

              @PeterJones @Ekopalypse Thank you both for your time and help. @PeterJones Please post here if the bug is fixed and I can Find all/search in multiple files of a folder

              1 Reply Last reply Reply Quote 0
              • PeterJonesP
                PeterJones @Ramanand Jhingade
                last edited by

                Please post here if the bug is fixed and I can Find all/search in multiple files of a folder

                Don’t misunderstand. Find in Files > Find All works for ASCII characters. And it works with valid characters in well-defined encodings (so a UTF-8-BOM or UCS-2-LE BOM file should properly search-and-replace with any valid character). It’s just when you’re making Notepad++ guess the encoding (one of the many character-set “encodings”) or when there are invalid characters (byte x93 all alone rather than in the appropriate mutli-byte sequence in a UTF-8 file). So, for your unusual use-case, it’s not currently working; but usually, it does.

                Ramanand JhingadeR 1 Reply Last reply Reply Quote 0
                • Ramanand JhingadeR
                  Ramanand Jhingade @PeterJones
                  last edited by

                  @PeterJones By God’s grace, the Find all/search in multiple files of a folder using the Regular expression mode finally worked after I removed all the files that did not end with the

                  .html
                  

                  extension. I thank you again from the bottom of my heart!

                  1 Reply Last reply Reply Quote 0
                  • PeterJonesP
                    PeterJones @Ramanand Jhingade
                    last edited by

                    (This post was in progress before your questions about Find All… I came back to this post later, so that future readers of the thread will know which character matches which.)

                    @Ramanand-Jhingade wrote:

                    I finally found a solution here: how-to-find-non-ascii-unprintable-characters-using-notepad-plus-plus
                    We have to select the Regular expression mode and search/find with this code: [\x00-\x08\x0B\x0C\x0E-\x1F\x7F-\x9F]

                    Good job! I applaud your persistence.

                    However, the solution surprises me.

                    It didn’t make sense to me that \x93 wouldn’t find “ but that [\x00-\x08\x0B\x0C\x0E-\x1F\x7F-\x9F] would. In an ANSI-encoded file, that search makes perfect sense, because those bytes aren’t in ASCII or extended-ASCII. But in a UTF-encoded file, those bytes aren’t valid unless they are part of a multi-byte UTF-8 encoding sequence.

                    So I started cutting parts out of that expression until I narrowed it down to what’s matching: \x13 matched the x93 byte.

                    With a UTF-8 encoded file that has bad bytes with the MSB set that don’t get interpreted as part of a multi-byte UTF-8 character sequence, the following appears true:

                    • \x13 will match the ce6ff162-2882-4f0b-81cc-2d32bfe75930-image.png
                    • \x14 will match the 0e546a47-6b43-4dfd-8817-c73d907c1d88-image.png

                    For example:
                    65a5dcd0-0dba-406a-a21c-aa6a418e73bf-image.png

                    So I built up a test file , and started doing searches:
                    1206b7d1-7f51-4646-9338-3a8b701a2fa2-image.png

                    • searching \x00 matches many, including x80, xA0, xB0, xB8, xBC, xBE, xC0, xE0, xF0, xF8, xFC, xFE
                    • searching \x01 matches eight, including x81, xA1, xB1, xB9, xBD, xC1, xE1, xF1, xF9, xFD
                    • searching \x02 matches eight, including x82, xA2, xB2, xBA, xC2, xE2, xF2, xFA
                    • searching \x03 matches eight, including x83, xA3, xB3, xBB, xC3, xE3, xF3, xFB
                    • searching \x04 matches six, including x84, xA4, xB4, xC4, xE4, xF4
                    • searching \x05, \x06, and \x07 each match the seven in the same pattern as \x04
                    • searching \x08 only matches four, including x88, xA8, xC8, xF8 . \x09 works analogously
                    • searching \x0A matches that same pattern of four, but also matches all the line-feed character in the EOL sequences
                    • searching \x0B and \x0C each match four, including x8B, xAB, xCB, xFB, x8C, xAC, xCC, xFC,
                    • searching \x0D matches the pattern of four, and all the carriage returns in the EOL sequences
                    • searching \x0E matches the pattern of four: x8E, xAE, xCE, xEE
                    • searching \x0F matches three of the four (but my file didn’t have x8F to match against)
                    • searching \x10 matches two: x90 and xD0. \x11, \x12, \x13, \x14, \x15, \x16, \x17, \x18, \x19, \x1A, \x1B, \x1C, \x1D, \x1E, \x1F all match the two entries from the 90 and D0 rows.

                    And no, @Alan-Kilborn , to answer your chat question, it does not change behavior inside of the [] character class.

                    As near as I can tell, in this poorly-encoded situation, the search engine seems to be applying certain bit-masks when searching for invalid bytes, where it masks out some of the upper bits while looking for matches. (My guess is that the multiple matches for a given search escape has to do with the fact that in valid UTF-8, 8-bit sequences that are 10xxxxxx can only be the second, third, or fourth byte of the multibyute sequence (so that’s 0x80-0xBF); 110xxxxx is the start of a 2-byte sequence (0xC0-0xDF); 1110xxxx is the start of a 3-byte sequence (0xE0-0xEF); and 1111xxxx is the start of a 4-byte sequence (0xF0-0xFF). But that’s a wild guess.)

                    Remember, all of these were for my experiments, with a file that Notepad++ is interpreting as UTF-8, but have these badly-encoded single bytes with spaces in between. This isn’t a general search technique in a well-formed file with the right encoding selected. None of this is best-practice, but is only here to help correct mal-formed UTF-8 files.

                    1 Reply Last reply Reply Quote 2
                    • guy038G
                      guy038
                      last edited by guy038

                      Hello, @ramanand-jhingade, @peterjones, @ekopalypse, @alan-kilborn and All,

                      Many thanks for your insight about invalid bytes in UTF8 encoded files. Very strange indeed !

                      So, in summary, if we use the non-regex notation x[U][V] to represent the invalid character xUV :

                      - The regex  \x00      matches the INVALID bytes x[8ABCEF][0]  and  x[BF][8CE]
                      - The regex  \x01      matches the INVALID bytes x[8ABCEF][1]  and  x[BF][9D]
                      - The regex  \x02      matches the INVALID bytes x[8ABCEF][2]  and  x[BF][A]
                      - The regex  \x03      matches the INVALID bytes x[8ABCEF][3]  and  x[BF][B]  and  \x[B][F]
                      - The regex  \x0[4-7]  matches the INVALID bytes x[8ABCEF][4-7]
                      - The regex  \x0[8-F]  matches the INVALID bytes x[8ACE][8-F]
                      - The regex  \x1[0-F]  matches the INVALID bytes x[9D][0-F]
                      

                      I tried to find out a general rule explaining these results… without success :-(

                      Note that the invalid byte xFF, in an UTF-8 encoded file, cannot be find with the notation \x[01][0-F]


                      Now, I think that @ramanand-jhingade could also find and replace the x93arulvaakkux94 string with the following regex S/R :

                      SEARCH [[:cntrl:]]arulvaakku[[:cntrl:]]

                      REPLACE "arulvaakku"

                      Note that, again, the Posix class [[:cntrl:]] is not able to match the invalid UTF-8 byte xFF !


                      As a remainder, here is, in a picture, some pieces of information about the UTF-8 encoding :

                      1841db4a-8322-453e-a9dd-039e634068f1-image.png

                      Best Regards

                      guy038

                      Alan KilbornA 1 Reply Last reply Reply Quote 3
                      • Alan KilbornA
                        Alan Kilborn @guy038
                        last edited by

                        @guy038 said in How to find and replace unrecognizable characters in multiple files of a folder with the correct character using Notepad ++?:

                        here is, in a picture, some pieces of information about the UTF-8 encoding

                        That’s a nice reference. Where is it from?

                        I’ve just been using Wikipedia’s similar pictorial reference --> HERE.

                        1 Reply Last reply Reply Quote 0
                        • guy038G
                          guy038
                          last edited by

                          Hi, @alan-kilborn and All,

                          No, just a personal presentation, in a Word document, of some parts of this article that I made some years ago, to fully understand the UTF-8 encoding ;-))

                          My first table is simply the extension to the complete UTF-8 encoding of the Unicode table, seen here, which is able to encode all the Unicode characters ( 1,114,112 )

                          With the complete UTF-8 encoding, up to six bytes, it can represent up to 134,217,728 characters ( so from U+0 to U+7FFFFFF )

                          As you can see, no problem for UTF-8 to encode all characters used in the different inhabited worlds of the galaxy !!!


                          And my second table is simply an other presentation of this one, on Wikipedia

                          BR

                          guy038

                          1 Reply Last reply Reply Quote 0
                          • First post
                            Last post
                          The Community of users of the Notepad++ text editor.
                          Powered by NodeBB | Contributors