How to merge 2 separate lines into 1 line for a numerous amount of data?

Michelle Fernandes

Text:
red, blue, green, orange
,black
red, blue, green, orange
,black
red, blue, green, orange
,black

What I need:
red, blue, green, orange, black
red, blue, green, orange, black
red, blue, green, orange, black

Alan Kilborn

@Michelle-Fernandes

Find: (?-s)^(.+)\R(.)
Repl: ${1}${2}
Search mode: Regular expression

M Andre Z Eckenrode

@Alan-Kilborn said in How to merge 2 separate lines into 1 line for a numerous amount of data?:

Find: (?-s)^(.+)\R(.)
Repl: ${1}${2}

Actually, looks like a space is wanted between , and black, where there was none before (though not sure if that was just a typo), so slight adjustment:

FIND: (?-s)^(.+)\R,(.)
REPLACE: ${1}, ${2}

Alan Kilborn

@M-Andre-Z-Eckenrode said in How to merge 2 separate lines into 1 line for a numerous amount of data?:

so slight adjustment

Well, if OP couldn’t make that slight adjustment by themselves, we’ve got some bigger problems…

M Andre Z Eckenrode

@Alan-Kilborn said in How to merge 2 separate lines into 1 line for a numerous amount of data?:

Well, if OP couldn’t make that slight adjustment by themselves, we’ve got some bigger problems…

Yeah, I guess… but I tend to operate on the assumption that there are others out there like me, who often struggle to distinguish forest from tree (hey, that rhymes!), and wish to help on the rare occasions I’m able. :-)

Alan Kilborn

@M-Andre-Z-Eckenrode said in How to merge 2 separate lines into 1 line for a numerous amount of data?:

wish to help on the rare occasions I’m able

Totally fine.

What scares me is someone asking a question, like the OP’s, taking the answers and doing what they need to immediately, but yet being afraid to experiment with the answers by trying things with them, and maybe learning something in the process. So that maybe next time they don’t have to ask, or maybe can help someone else out (like you did).

M Andre Z Eckenrode

@Alan-Kilborn said in How to merge 2 separate lines into 1 line for a numerous amount of data?:

yet being afraid to experiment with the answers by trying things with them, and maybe learning something in the process. So that maybe next time they don’t have to ask, or maybe can help someone else out (like you did).

It would certainly be great if everybody had the same capacity to experiment and learn, but that’s unfortunately not the case, in my experience. Speaking for myself, I often do experiment, and hope to learn, but have a tendency to get discouraged when my experiments lead to more questions, as seen in my “Replace character in capture group” thread.

Michelle Fernandes

@M-Andre-Z-Eckenrode said in How to merge 2 separate lines into 1 line for a numerous amount of data?:

${1}, ${2}

Thank you! This worked.