Notepad++ - Delete Line Starts with to end of line

Question

I have lot of queries like this:

create table results
(
  id bigint,
  order_id bigint,
  article_id bigint default 0 ,
  check_id bigint,
  status text(1),
  total_units bigint,
  units_checked bigint,
  endtime bigint default 0,
  tenantid text(5),

  PRIMARY KEY (id,check_id,order_id, article_id, (tenantid,order_id,article_id,check_id))
--  constraint results_id_pk primary key (id),
--  constraint results_check_id_fk foreign key (check_id) references checks (id),
--  constraint results_order_id_fk foreign key (order_id) references orders (id),
--  constraint results_article_id_fk foreign key (article_id) references articles (id),
--  unique(tenantid,order_id,article_id,check_id)
  );

I like to delete all lines starts with '--'.

I tried as suggested in Delete all lines starting with # or ; in Notepad++

^[-].*
^(-).*\r\n
^(\s)*(-).*(\r\n|\r|\n)?

Unfortunately not working for me.

Did you try `^--.*`? Or `^--.*\R?`? Surely `^[#;].*` will not work because you need to remove lines that start with `--`, not `#` or `;`. — Wiktor Stribiżew, Jan 11 '18 at 09:55
Use the find all with - - and replace with a space. Would that not work? — Scott Chambers, Jan 11 '18 at 09:55

score 0 · Answer 1 · answered Jan 11 '18 at 09:58

0

^[#;].* : Says remove lines starting with # or ;

You need to remove lines starting with -- so please try ^--.*

answered Jan 11 '18 at 09:58

nbirla

590
3
13

StefansArya · Answer 2 · 2018-01-11T10:08:54.180

0

Try with \n followed by -- and match any character after it

\n--.*

edited Jan 11 '18 at 10:08

answered Jan 11 '18 at 09:58

StefansArya

2,494
3
21
23

Notepad++ - Delete Line Starts with to end of line

2 Answers2