Re: [R] Quotes inside char string

2011-12-20 Thread Mike Pfeiff
Duncan, Thank you for referring me to Uwe's answer. -Original Message- From: Duncan Murdoch [mailto:murdoch.dun...@gmail.com] Sent: Tuesday, December 20, 2011 1:14 PM To: Mike Pfeiff Cc: 'R-help@r-project.org' Subject: Re: [R] Quotes inside char string On 20/12/201

Re: [R] Quotes inside char string

2011-12-20 Thread Mike Pfeiff
e] Sent: Tuesday, December 20, 2011 1:20 PM To: Mike Pfeiff Cc: 'R-help@r-project.org' Subject: Re: [R] Quotes inside char string On 20.12.2011 20:10, Mike Pfeiff wrote: > How do I return a character string with quotes inside string? > > For example, what logic do I use if

[R] Quotes inside char string

2011-12-20 Thread Mike Pfeiff
How do I return a character string with quotes inside string? For example, what logic do I use if I want to return the following: Test Score="A" I tried the following Score<-paste("Test Score=","A",sep='"') But it returned a "\" inside: "Test Score=\"A"

Re: [R] RODBC Error: 'getCharCE' must be called on a CHARSXP

2011-12-20 Thread Mike Pfeiff
e extra "\"' is improper SQL form. Maybe I should be asking what is the proper way to return "" inside of a char string? -Original Message- From: Uwe Ligges [mailto:lig...@statistik.tu-dortmund.de] Sent: Tuesday, December 20, 2011 8:46 AM To: Mike Pfeiff Cc: 

[R] RODBC Error: 'getCharCE' must be called on a CHARSXP

2011-12-20 Thread Mike Pfeiff
I am trying to connect to an internal database and use the sqlQuery command to reduce and retrieve data using the following code: channel <-odbcConnect("some_dsn", uid="", pwd="") txt<-'SELECT Date, Region, Price FROM TableXYZ WHERE Type="Domestic"' sqlQuery(channel, cat(txt,"\n"),errors=TRUE,) c

Re: [R] read .csv from web from password protected site

2011-10-03 Thread Mike Pfeiff
e website do not require me to reenter info. -Original Message- From: Sarah Goslee [mailto:sarah.gos...@gmail.com] Sent: Monday, October 03, 2011 3:07 PM To: Mike Pfeiff; r-help Subject: Re: [R] read .csv from web from password protected site Hi, I've assumed that you meant to se

[R] read .csv from web from password protected site

2011-10-03 Thread Mike Pfeiff
I am very new to R and have been struggling trying to read a basic ".csv" file from a password protected site with the following code: myURL ="http://www.frontierweather.com/degreedays/L15N15PowerRegionAverages_10weeks.txt"; test2=read.table(url(myURL),header=TRUE,sep=",") A 'data.frame' is re