-2

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
Emma
  • 26,487
  • 10
  • 35
  • 65
Siva24
  • 1
  • 1
  • Possible duplicate of [Learning Regular Expressions](https://stackoverflow.com/questions/4736/learning-regular-expressions) – AdrianHHH Jul 14 '19 at 04:55

2 Answers2

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.

Emma
  • 26,487
  • 10
  • 35
  • 65
1
  • Ctrl+H
  • Find what: :\s+
  • Replace with: : # a colon followed by a space
  • check Wrap around
  • check Regular expression
  • Replace all

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:

enter image description here

Toto
  • 86,179
  • 61
  • 85
  • 118