Regualr Expression Help

[Mike Kovach]

Have a small task to merge data into individual lines.

What I am looking to do is like the following:

libogg-Red Hat Inc.
1.1.3
THERE IS A SPACE HERE and then other like data after the sapce.

Thake those two lines and have it look like libogg-Red Hat Inc.,1.13
and then remove the empty space. I’m looking to do this for 20000 rows of data. ANy one have any ideas on how to accomplish this?

[jonandr]

Replace

(.+)\r\n(.+)

with

\1, \2

Then remove the empty lines.

[Mike Kovach]

Worked perfectly, that you.