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

  • 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.

  • @Vic-Paine


    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 ).

  • @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.

Log in to reply