regex - How to insert a line break every five rows in Excel/Word/Notepad++? -
i have list:
08:17
17:01
08:09
16:56
09:22
17:01
08:08
17:05
07:59
16:54
.
.
.
how insert linebreak each 5 rows in excel/word/notepad? (not < br >)
for example:
08:17
17:01
08:09
16:56
09:22
(line break here)
08:08
17:05
07:59
16:54
08:02
(line break here)
etc
etc
i've tried /n/r/n/r can't figure out, have use code or there tool textfx/notepad++ or has feature?
using notepad++ find/replace in regex mode:
find: ((.*\s*\n\s*){5}) replace: $1\n
cheers.
Comments
Post a Comment