• Login
Community
  • Login

I have txt file with [CR CR\LF] how do I remove CR\LF but leave first CR?

Scheduled Pinned Locked Moved General Discussion
3 Posts 2 Posters 4.9k 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.
  • V
    Vic Paine
    last edited by Oct 16, 2017, 11:17 AM

    This is a very large file (26515 lines) that has a blank line between every entry when loaded into a spreadsheet. I would like to remove the blank lines (redundant CR\LF) before loading into spreadsheet. I have tried find (without replacing) but however I enter the [\r\n] it always finds the single CR as well.

    S 1 Reply Last reply Oct 16, 2017, 12:10 PM Reply Quote 0
    • S
      Scott Sumner @Vic Paine
      last edited by Oct 16, 2017, 12:10 PM

      @Vic-Paine

      Try:

      Find what zone: (\R)+
      Replace with zone: \1
      Search mode radio-button: Regular expression

      Translation: Match one or more adjacent line-endings…replace matches with simply a single line-ending.

      If this (or ANY posting on the Notepad++ Community site) is useful, don’t reply with a “thanks”, simply up-vote ( click the ^ in the ^ 0 v area on the right ).

      V 1 Reply Last reply Oct 16, 2017, 1:08 PM Reply Quote 1
      • V
        Vic Paine @Scott Sumner
        last edited by Oct 16, 2017, 1:08 PM

        @Scott-Sumner
        Thanks, worked a treat. Also found that if I opened it in Libre Office Writer and saved as *.csv it cleared unwanted blank lines as well.

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