How do I go from A<CR><<LF>B<CR><LF> to 'A','B' ?

Jim Biwer

How to I quickly change (search/replace):

A<CR><LF>
B<CR><LF>
C<CR><LF>
D

to

‘A’,‘B’,‘C’,‘D’
?

I have done it before using Ultra Edit, but I am new to N++.
Thank you!

Claudia Frank

Hello @Jim-Biwer,

by using regular expressions and find/replace dialog.

CTRL+H
check regular expression (bottom left)

find what:(.*)\r\n
replace with:‘\1’,

(.)\r\n = you are looking for text which end with CRLF
(.) = holds the text without the eol chars
\1 = what (.*) returns
encased by quote and added a comma as you’ve told.

It results in ‘A’,‘B’,‘C’,‘D’, so you need to delete the last comma manually.

Cheers
Claudia

Jim Biwer

Thanks, I will give it a try.

Jim Biwer

Got it, works good. Thank you!

Jim Biwer

Yes, works great. Thank you.

Jim Biwer

In Ultra Edit, I would search for ^p and replace with ‘,’

Thanks again. Solved.