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

[Phil Spector]

Mai -

> sql=c("-- This is a comment line",
+          "select sysdate  -- This is a comment Text" ,
+          " from dual ")
> use = sub('--.*$','',sql)
> use[use != '']
[1] "select sysdate  " " from dual "

Although to get it to print the way you listed, you need
to reduce the width of the line:

> options(width=20)
> use[use != '']
[1] "select sysdate  "
[2] " from dual "

 					- Phil Spector
 					 Statistical Computing Facility
 					 Department of Statistics
 					 UC Berkeley
 					 spector at stat.berkeley.edu


On Tue, 22 Feb 2011, Mai Dang wrote:

> 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
>
> ______________________________________________
> R-help at r-project.org mailing list
> https://stat.ethz.ch/mailman/listinfo/r-help
> PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
> and provide commented, minimal, self-contained, reproducible code.
>