[R] File to MYSQL

Patrick Connolly p_connolly at slingshot.co.nz
Mon May 16 22:06:08 CEST 2011


On Mon, 16-May-2011 at 02:55PM -0300, Nilza BARROS wrote:

|> Dear R-user,

[...]

|> 2) My script
|> 
|> outfile<- with(as.data.frame(Alldados),sprintf("INSERT INTO OBS
|> (date,TMAX_2M,TMIN_2M,TD_2M,PS,FF_10M,DD_10M,Station_NO) VALUES (%s, %s, %s,
|> %s,%s,%s,%s,%s)",date2,TMAX_2M,TMIN_2M,TD_2M,PS,Station_NO))
|> write.table(outfile,file=paste(dat.dir,"outfile_13mai.txt",sep=""),append=FALSE,col.names=FALSE,

Have you tried quote = FALSE also?

|> row.names=FALSE)

[...]


HTH

-- 
~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.   
   ___    Patrick Connolly   
 {~._.~}                   Great minds discuss ideas    
 _( Y )_  	         Average minds discuss events 
(:_~*~_:)                  Small minds discuss people  
 (_)-(_)  	                      ..... Eleanor Roosevelt
	  
~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.



More information about the R-help mailing list