[R] Delete Comment Lines from SQL String as a Vector

[Mai Dang]

Hi,
I tried to remove the text starts by "--" to the end of the line as below


sql=c("-- This is a comment line",
         "select sysdate  -- This is a comment Text" ,
         " from dual ")
>sql
[1] "-- This is a comment line"
[2] "select sysdate  -- This is a comment Text"
[3] " from dual "


I try to have this
> sql
[1] "select sysdate "
[2] " from dual "

Thank You for your help,
Mai Dang