Remove CR LF for all lines that are not followed by a specific number

Posted by Kjeldsen on Super User See other posts from Super User or by Kjeldsen
Published on 2014-08-19T09:28:40Z Indexed on 2014/08/19 10:23 UTC
Read the original article Hit count: 199

Filed under:

notepad++

|

find-and-replace

I have 14000+ lines of a database, that I want to edit with Notepad++. All these lines should start with 1000 and I therefore want to delete CR LF at the end of those lines that are not followed by 1000.

Eg.
1000 16 04000 CRLF
sdfsdf 15 sdf de 05550 CRLF
1000 16 04000 CRLF
1000 16 04000 CRLF
5. sdkfd dksds 16 0555 CRLF
10/10/14 sdfsdf CRLF

should after find and replace look like
1000 16 04000 sdfsdf 15 sdf de 05550 CRLF
1000 16 04000 CRLF
1000 16 04000 5. sdkfd dksds 16 0555 10 sdfsdf CRLF

I have tried with find what: \r\n([^1000]) Replace with _\1
However, this doesn't seem to remove lines starting with a number (like 5. or 10/10/14). Is it possible to make just one RegEx to find and remove all line breaks that isn't followed by 1000?

"_" indicating a "space"

© Super User or respective owner

Related posts about notepad++

How to make Notepad++ take over from the standard notepad.exe

as seen on Super User - Search for 'Super User'
I could do this easily with TextPad, then I got irritated with Textpad once I'd played with Notepad++. Now that I've removed Textpad: I want Notepad++ to take over the right-click Edit option in Explorer, and I want Notepad++ to come up when I type notepad in the command prompt. I know that… >>> More
Open text file in notepad/notepad++ based on size

as seen on Super User - Search for 'Super User'
Hi, When i double click a text document, if that text file is more than 1MB(or some specified size) I want that text file to be opened in Notepad++ while the files that are smaller should be opened in notepad itself. Is there any way i can achieve this.? Thanks >>> More
Notepad++ doesn't launch (notepad++.exe present in the task manager)

as seen on Super User - Search for 'Super User'
Yesterday Notepad++ was runnable, but today it doesn't. In spite of the notepad++.exe (with its 13 process) presence is the tasks manager, Notepad++ window doesn't launch. I tried to uninstall and re-install the sofware (and the first launch works), notepad.exe is present in C:\Windows and C:\Windows\Sytem32… >>> More
EOL in Notepad++ and Notepad

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm using Notepad++ to create some text file, but I noticed when the generated file is opened in Windows Notepad, the file contents get mal-formated due to the fact that Notepad++ use LF and EOL character, while Notepad expects CR + LF. Is there any way to change this behavior in Notepad++?? >>> More
Useful utilities - PFE, Notepad++ and XML Notepad 2007

as seen on Geeks with Blogs - Search for 'Geeks with Blogs'
All three editors are free to download and use! PFE http://www.lancs.ac.uk/staff/steveb/cpaap/pfe XML Notepad 2007 http://www.microsoft.com/downloads/details.aspx?familyid=72d6aa49-787d-4118-ba5f-4f30fe913628&displaylang=en Notepad++ http://notepad-plus.sourceforge.net/uk/download… >>> More

Related posts about find-and-replace

How do I find and replace 'whole words only', in Microsoft Word?

as seen on Super User - Search for 'Super User'
I want to be able to find and replace eat with Eat in Microsoft Word 2007. However, I don’t want to replace every occurrence of eat such as those that can be found inside other words such as great and meat. I have tried doing this using the regular Find and Replace tool, but I get words with capital… >>> More
Find and Replace several several different values all at once

as seen on Super User - Search for 'Super User'
I have a file with multiple instances of Text_1 and Text1 and I need to replace both those strings with Text_A and TextB respectively. Currently I'm doing two Find and Replace functions on each file one that finds Text_1 and replaces it with Text_A and the other that finds Text1 and replaces it… >>> More
Find and replace in a block of text.

as seen on Stack Overflow - Search for 'Stack Overflow'
I have a database full of text fields that look like this: (paragraph of normal text) image:blog/clownboy.jpg (another paragraph) I'm trying to write a view helper for Rails that will take one of these big blocks of text, find bits like "image:blog/clownboy.jpg" and replace them with the corresponding… >>> More
Java List with Objects - find and replace (delete) entry if Object with certain attribute already ex

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi there I've been working all day and I somehow can't get this probably easy task figured out - probably a lack of coffee... I have a synchronizedList where some Objects are being stored. Those objects have a field which is something like an ID. These objects carry information about a user and his… >>> More
Find and replace string in MySQL using data from another table

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi, sorry for formatting this wonky but hope you can understand it. I have two MySql tables, and I want to find and replace text strings in one using data in another. Texts - one column: messages 'thx guys' 'i think u r great' 'thx again' ' u rock' Dictionary - two columns: bad_spelling, good_spelling 'thx'… >>> More