Reputation: 934
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.
Upvotes: 4
Views: 38546
Reputation: 365
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/
Upvotes: 3
Reputation: 2319
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 match CR
with \r
and LF
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 :)
Upvotes: 3
Reputation: 3475
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 ( )
.
Upvotes: 15