[R] quote problem

From: Tom Van Engeland <tvanengeland_at_yahoo.co.uk>
Date: Fri 10 Feb 2006 - 02:30:59 EST

  I'm trying to analyse information from a large database using R. I have some problems with quotes during the generation of strings.    

  Setting: I extract data from a lot of sampling location (chemical data on water quality)   and for each location I have a date of sampling and a value. I want to put everything in a list such that for each sampling point (say OS1) I have two columns (date, time). I use the function sqlQuery from the RODBC package.    

  Here is an example that works:
  OxygenMeasurements$OS1 <- sqlQuery(channel, "SELECT saDateTime, sdValue FROM dbo_Sample WHERE (paID = 213) AND (stCode ='OS1');")    

  To keep the code "elegant" and, above all, short I try to regenerate the same   function call with a different query statement for each sampling point by using   the paste() function.    

(1) sqlquery <- paste("SELECT saDateTime, sdValue FROM dbo_Sample WHERE (paID = 213) AND (stCode ='" , paste(stations$stCode, sep=",") , "');" , sep="")
  This gives a vector with the sql syntax. The following line generates the whole sqlQuery-statement.    

(2) queries <- paste("OxygenMeasurements$", paste(stations[,1]), " <- sqlQuery(channel, \"", paste(sqlquery) , " \")" , sep="")

  This is the result for the first two elements of 'queries':    

  "OxygenMeasurements$OS1 <- sqlQuery(channel, \"SELECT saDateTime, sdValue FROM dbo_Sample WHERE (paID = 213) AND (stCode ='OS1'); \")"   "OxygenMeasurements$OS2 <- sqlQuery(channel, \"SELECT saDateTime, sdValue FROM dbo_Sample WHERE (paID = 213) AND (stCode ='OS2'); \")"    

  If these are evaluated ( eval(queries)) it should fill the datastructure "OxygenMeasurements" with the desired data.    

  The problem:
  The query statement containts a string and is a string in itself. In addition elements of 'queries' are strings. R doesn't seem to be able to cope with this, since it generates \" on locations where a " has to be put. Is there a way to let the paste function generate   a string with " in it without the \ ?    

  In a way there are 3 nested strings and R can only cope with 2 levels (by using ' and ") in my view.    

  Does anyone know how to put " IN the string instead of \"?    

  Thanks for the feedback.    


Win a BlackBerry device from O2 with Yahoo!. Enter now.

        [[alternative HTML version deleted]]

R-help@stat.math.ethz.ch mailing list
https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide! http://www.R-project.org/posting-guide.html Received on Fri Feb 10 03:30:27 2006

This archive was generated by hypermail 2.1.8 : Sat 11 Feb 2006 - 02:03:54 EST