Remove Unwanted Space & empty line and merge into single line with grouping.
-
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
VasanLine 2
Sachin
TendulkarActual:
Srini Vasan
Sachin TendulkarI 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
-
@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.
Hello! It looks like you're interested in this conversation, but you don't have an account yet.
Getting fed up of having to scroll through the same posts each visit? When you register for an account, you'll always come back to exactly where you were before, and choose to be notified of new replies (either via email, or push notification). You'll also be able to save bookmarks and upvote posts to show your appreciation to other community members.
With your input, this post could be even better 💗
Register Login