Community

    • Login
    • Search
    • Recent
    • Tags
    • Popular
    • Users
    • Groups
    • Search

    Search & Replace with carriage return?

    General Discussion
    2
    3
    37358
    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.
    • EP Pack
      EP Pack last edited by

      I have a file that has data copied in from another source, which did not hold any carriage returns. It looks like this:

      “value 1” “value 2” “value 3” “value 4” etc

      It contains the quotes as shown above, which is fine, as it gives me a good set of delimiters for this action, and I"m OK with leaving them in the file.

      What I WANT is this:

      “value 1”
      “value 2”
      “value 3”
      “value 4”
      etc

      Before I retired, I was a long time user of Ultraedit which could handle this just fine without any special escape characters or the like, but I’m unsure how to do it in NPP, to which I’m fairly new and haven’t done all that much with yet other than typical text stuff. Can anyone point me to a plugin or help topic or the like?

      THANKS!!

      elaine

      1 Reply Last reply Reply Quote -1
      • guy038
        guy038 last edited by guy038

        Hello, @ep-pack,

        Quite easy with regular expression search mode ;-)

        So given the text, below :

        "value 1" "value 2" "value 3" "value 4"
        

        I supposed that there is, only, one space character between the two quotation marks. Anyway, my regex S/R will work, with any standard character, between quotes !

        Then,

        • Open your file in Notepad++

        • Open the Replace dialog ( Ctrl + H )

        • Type in the regex (?-s)"." , in the Find what: zone

        • Type in the regex "\r\n", in the Replace with: zone

        • Tick the Wrap around option

        • select the Regular expression search mode

        • Click, once, on the Replace All button ( or several times on the Replace button ! )

        Voilà ! You should get the following text :

        "value 1"
        "value 2"
        "value 3"
        "value 4"
        

        Notes :

        • First the modifier (?-s) forces the regex engine to interpret the dot ., as matching a single standard character ( different from End of line ones ! )

        • Then, the part "." matches two quotation marks, separated by any standard character

        • In replacement, we rewrite the two quotation marks, separated with \r\n, which represents a line-break ( Carriage Return + Line Feed )

        • Note that, if you use Unix files, change the replacement regex to "\n"

        Best Regards

        guy038

        P.S. :

        For noob people, about regular expressions concept and syntax, begin with that article, in N++ Wiki :

        http://docs.notepad-plus-plus.org/index.php/Regular_Expressions

        In addition, you’ll find good documentation, about the Boost C++ Regex library, v1.55.0 ( similar to the PERL Regular Common Expressions, v5.8 ), used by Notepad++, since its 6.0 version, at the two addresses below :

        http://www.boost.org/doc/libs/1_55_0/libs/regex/doc/html/boost_regex/syntax/perl_syntax.html

        http://www.boost.org/doc/libs/1_55_0/libs/regex/doc/html/boost_regex/format/boost_format_syntax.html

        • The FIRST link explains the syntax, of regular expressions, in the SEARCH part

        • The SECOND link explains the syntax, of regular expressions, in the REPLACEMENT part


        You may, also, look for valuable information, on the sites, below :

        http://www.regular-expressions.info

        http://www.rexegg.com

        http://perldoc.perl.org/perlre.html

        Be aware that, as any documentation, it may contain some errors ! Anyway, if you detected one, that’s good news : you’re improving ;-))

        1 Reply Last reply Reply Quote 1
        • EP Pack
          EP Pack last edited by

          @guy038 said:

          “\r\n”

          Thank you so much! It worked perfectly! Just needed a pointer to the solution, syntax-wise. I’m reasonably familiar using regex, but not with this application.

          Again, thanks!
          elaine

          1 Reply Last reply Reply Quote 0
          • First post
            Last post
          Copyright © 2014 NodeBB Forums | Contributors