How to find and replace a string with newline in emeditor

Asked Aug 11 '20 at 08:51

Active Aug 11 '20 at 08:56

Viewed 22 times

I have the data in the following format;

(1,NULL,NULL,'Chief p','[email protected]','new',4,'1ef7,0,2),(1,NULL,NULL,'Chief Pollster','[email protected]','new',4,'1ef7,0,2),(1,NULL,NULL,'Chief Pollster','[email protected]','new',4,'1ef7,0,2),(1,NULL,NULL,'Chief Pollster','[email protected]','new',4,'1ef7,0,2),

I am trying to achieve the following:

(1,NULL,NULL,'Chief p','[email protected]','new',4,'1ef7,0,2),
(1,NULL,NULL,'Chief Pollster','[email protected]','new',4,'1ef7,0,2),
(1,NULL,NULL,'Chief Pollster','[email protected]','new',4,'1ef7,0,2),
(1,NULL,NULL,'Chief Pollster','[email protected]','new',4,'1ef7,0,2),

So I tried the following regex

find ),\s* and replace it with ),\n

But it says

The regex contains mismatched '(' and ')'

What am I doing wrong?

edited Aug 11 '20 at 08:56

asked Aug 11 '20 at 08:51

blunT

`)` is a special char, it ust be escaped in the regex pattern. – Wiktor Stribiżew Aug 11 '20 at 08:53
I found this to be working: Searched `)` and replace it with `/n` while I selected "Escape sequence" – blunT Aug 11 '20 at 08:59

How to find and replace a string with newline in emeditor

0 Answers0