How to add second line text after colon in notepad++?

Question

Guys i want the second line text to be after the colon , how to do in notepad++ ?? or any other available ???

Data i have is below

SNO :
19110
BLKNAME :
SETHUBAVACHATRAM
DISTRICTNA : 
THANJAVUR
PANCHTYPE :  
VP
RVILLNAME :  
SEMBIYAMADEVIPATTINAM
TALUKNAME :  
Peravurani

Expecting to like this -

SNO : 19110
BLKNAME : SETHUBAVACHATRAM
DISTRICTNA : THANJAVUR
PANCHTYPE : VP
RVILLNAME : SEMBIYAMADEVIPATTINAM
TALUKNAME : Peravurani

Possible duplicate of [Learning Regular Expressions](https://stackoverflow.com/questions/4736/learning-regular-expressions) — AdrianHHH, Jul 14 '19 at 04:55

score 2 · Answer 1 · answered Jul 14 '19 at 08:49

Explanation:

:           # a colon
\s+         # 1 or more spaces (including linebreak)

Result for given example:

SNO : 19110
BLKNAME : SETHUBAVACHATRAM
DISTRICTNA : THANJAVUR
PANCHTYPE : VP
RVILLNAME : SEMBIYAMADEVIPATTINAM
TALUKNAME : Peravurani

Screen capture:

score 1 · Answer 2 · answered Jul 14 '19 at 04:50

1

Here, we can most likely use this regular expression:

([^:]+):\s*(.*)

and make a replacement with:

$1: $2

and it might work.

The expression is explained on the top right panel of this demo if you wish to explore/simplify/modify it.

answered Jul 14 '19 at 04:50

Emma

2 Answers2