On 15/07/2009 7:28 AM, Paulo E. Cardoso wrote:> I need to get the exact sentence, with the quotes:
>
>
>
> OPTIONS COORDSYS("Surface1" AS COMPONENT);
>
>
>
> but this:
>
>
>
> options(useFancyQuotes = F)
>
> paste("OPTIONS COORDSYS(", dQuote("Surface 1"),
"AS COMPONENT);" )
>
>
>
> give me this:
>
>
>
> [1] "OPTIONS COORDSYS( \"Surface 1\" AS COMPONENT);"
>
>
>
> And it's not readable as SpatialSQL code by GIS
>
>
>
> How to deal with this problem?
Your string is fine, it is only being displayed with escapes. If you
want to see it as it is, use cat(), not the default print(). For example,
> cat("OPTIONS COORDSYS( \"Surface 1\" AS
COMPONENT);\n")
OPTIONS COORDSYS( "Surface 1" AS COMPONENT);
Duncan Murdoch