Replace New Lines with Comma (RNLC)

Hi guys, I still have some enthusiasm left, I don't want to miss out on how to change a new line (the result of pressing the enter button) into one line and replace it with a comma (,).

If there are only 2 or 3 rows, maybe you don't need this ultimate method, but what if there are 1000 rows? It would be crazy if you still use the manual method.

You need to know, you can do this ultimate method in any type of text editor you have, be it regular notepad, notepad++, sublime, wordpad, vs code, android studio, ms office, etc.

The basic principle of this ultimate method is to implement regular expressions (regex).

Okay, let's just say I have a case like this.

Apples
Apricots
Pear
Avocados
Bananas

Then, I wanted to make it like this.

Apples, Apricots, Pear, Avocados, Bananas

Solution

As always make sure you are on the "Find and Replace" page. Whatever your text editor, make sure you are in regular expression mode.

In the Find column, input this expression.

[\r\n]+

Meanwhile, in the Replace column, input a comma and a space.

,

Okay, please execute and see the result. Good Job!