I have some statements like this in notepad ++
INSERT INTO ZZZZZZZ (A,B,C,D)
VALUES (1,2,3,4)
;
I need to put the semicolon after the end of line 2 for all the occurrences.
Desired output :
INSERT INTO ZZZZZZZ (A,B,C,D)
VALUES (1,2,3,4);
How to do that in notepad++
>Solution :
You may try the following find and replace, in regex mode:
Find: $\R;
Replace: ;