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.
Find what zone:
Replace with zone:
Search mode radio-button:
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
^ 0 varea on the right ).
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.