I have this sample, because is one of one million rows with that. I have this text:
<tr class="even">
<td><a href="http://www.ujk.edu.pl/">Jan Kochanowski
University of Humanities and Sciences (Swietokrzyska Pedagogical
University) / Uniwersytet Humanistyczno Przyrodniczy Jana Kochanowskiego
w Kielcach</a></td>
I want to replace to be like that:
<tr class="even">
<td><a href="http://www.ujk.edu.pl/">Jan Kochanowski University of Humanities and Sciences (Swietokrzyska Pedagogical University) / Uniwersytet Humanistyczno Przyrodniczy Jana Kochanowskiegow Kielcach</a></td>
I tried that REGEX: (.*) But didn't work.
Open Notepad++
Click Search >> Replace..
Replace with: \n
At the bottom you will find "Search Mode", click "Extended"
Live example here: http://postimg.org/image/c66pw8kkr/
If you can't make jmstoker's solution work, try like this:
CRLF
or just one of them, for that, click on the toolbar the icon "show all characters" or go to menu View -> Show Symbol -> Show all characters\r\n
(or just\r
or just\n
, basically matchCR
with\r
andLF
with\n
)<tr class="even">
to be on its own line, so just replace still using an extended search<tr class="even"><td>
with<tr class="even">\r\n<td>
I'm guessing you also have rows with class "odd" or something like that so you might need to repeat that last step with the different class :)
Open the replace window with Ctrl + H
Then enter
Find what:
([^>])[\r\n]{1,2}
Replace with:
\1
Check
Regular Expression
[^>]
matches a character that isn't a>
The
{1,2}
protects against a file that may only have a newline and not a carriage return.\1
replaces just the character that was in the grouping( )
.