Remove Unwanted Space & empty line and merge into single line with grouping.

[Srinivasan k.d.]

Hello, I need your help to sort out below issue. Actually We have data like these in our file and it should be changed to actual one. Please refer below .

Current -> Line 1
Srini
Vasan

Line 2

Sachin
Tendulkar

Actual:
Srini Vasan
Sachin Tendulkar

I experimented for remove blank line and merge into single line. but i need line 1 & line 2 separately. Please share your thoughts if anyone knows. Thanks

[dr ramaanand]

@Srinivasan-k-d Simple, type Srini\RVasan in the Find what field and Srini Vasan in the Replace with field, tick the Regular expression mode and hit Replace, you will get Srini Vasan. Then, type Sachin\RTendulkar in the Find what field and Sachin Tendulkar in the Replace with field, tick the Regular expression mode and hit Replace, you will get Sachin Tendulkar. If there are some white spaces in between Srini and Vasan and Sachin and Tendulkar, use \s* instead of \R. Then, press ctrl + h (Shortcut for replace). Then, in the Find what zone, type ^\R ( for empty lines only) or ^\h*\R ( for empty lines with blank spaces only) and leave the Replace with zone empty. Then, tick the Wrap around option. Then, select the Regular expression search mode. Then, click on the Replace All button and all the blank lines will be removed.