Remove Comments from MYSQL File

Question

Which I thought as the answer, but that still leaves the newline which I also need to remove:

sql = `HELLO 1
-- comments 1
HELLO 2
-- comments 2
HELLO3
`;

sql.replace(/.*--.*/g,'');

But this still leaves spaces and does not remove the whole line:

HELLO 1

HELLO 2

HELLO3

What I am looking for is this:

HELLO 1
HELLO 2
HELLO3

How can I achieve this in the regex without executing a second replace to replace blank lines ?

Append ```\r?\n|\r``` to your regex to remove newlines ... have a look here: https://stackoverflow.com/questions/10805125/how-to-remove-all-line-breaks-from-a-string — Mischa, Nov 11 '20 at 09:48
Thanks, but cannot remove newlines as they might be valid, the regex need to match the line starting with -- and remove it — crankshaft, Nov 11 '20 at 09:50

score 0 · Accepted Answer · answered Nov 11 '20 at 09:48

0

Maybe this can help you:

\n(\/\*[^*]*\*\/)|(\/\/[^*]*)|\n(--[^.].*)

Code:

sql = `HELLO 1
-- comments 1
HELLO 2
-- comments 2
HELLO3
`;

sql.replace(/\n(\/\*[^*]*\*\/)|(\/\/[^*]*)|\n(--[^.].*)/g,'');

answered Nov 11 '20 at 09:48

Alireza

1 Answers1