# If you'd like to omit non-matching lines from the result; add ';d' to the end of the expression.
sed -E 's/'[^']*(?!\\)'(*SKIP)(*F) # Make sure we're not matching inside of quotes
|(?m-s:\s*(?:\-{2}|\#)[^\n]*$) # Single line comment
|(?:
\\/\*.*?\*\\/ # Multi-line comment
(?(?=(?m-s:[\t ]+$)) # Get trailing whitespace if any exists and only if it's the rest of the line
[\t ]+
)
)//gxs;t' <<< "CALL agr_agreement(
1,
13075,
'HBO Latin America--this is a test',
'(123) 456-7890',
'M',
'John Doe',
'john@doecom',
'Miami',
'(123) 456-7890',
'Net 30',
'Quarterly',
0,
'2014-09-01',
'2014-09-01', /*
This is a multi''-line comment
*/
'2017-08-31', -- single line comment
36,
/*Inline, but multi-line comment*/'2015-03-26 06:59:44',
@status
);"
Please keep in mind that these code samples are automatically generated and are not guaranteed to work. If you find any syntax errors, feel free to submit a bug report. For a full regex reference for SED, please visit: https://www.gnu.org/software/sed/manual/html_node/The-_0022s_0022-Command.html