Thanks again for your help. I am wanting my variable to store a character string exactly as the write.csv function would store as a csv text file;
IE: My goal is to store a data frame of this construction; x1 x2 1 2 3 4 as "X1","X2",1,2,3,4 (the same format as CSV). I am aware of the file argument, however that is the problem, storing to a physical text file and then importing into the SQL database is a very inefficient way of doing things, especially when I can use RMySQL to send commands directly to the database. Kind Regards, Tristan Casey BPsySci (UQ) + 4 Festa Court, Capalaba, QLD 4157 H 8/33 Lilly St, Greenslopes, QLD 4120 0450 033 948 > Date: Fri, 29 Feb 2008 05:12:04 +0000 > From: [EMAIL PROTECTED] > To: [EMAIL PROTECTED] > CC: [EMAIL PROTECTED]; r-help@r-project.org > Subject: Re: [R] write.csv +RMySQL request > > On Thu, 28 Feb 2008, jim holtman wrote: > > > ?capture.output > > > > myoutput <- capture.output(write.csv(...)) > > It would be better to write directly to a text connection: see the 'file' > argument to write.csv. > > > On Thu, Feb 28, 2008 at 7:34 PM, Tristan Casey <[EMAIL PROTECTED]> wrote: > >> Hello, > >> > >> I am relatively new to R and learning its ins and outs. As part of a > >> website I am building, I need to read and write csv files directly from an > >> SQL database. Basically I want to convert R variables (dataframes) into > >> CSV format, store them as another R variable (as a properly formatted text > >> string suitable for csv reading) and then send this to one row in a > >> database. > >> > >> The SQL part is fine, the problem arises because I cannot capture the > >> output of write.csv! It posts to the terminal when file="" is used, > >> however I also want to store it. Does anyone have any ideas? > >> > >> Thanks in advance! > > -- > Brian D. Ripley, [EMAIL PROTECTED] > Professor of Applied Statistics, http://www.stats.ox.ac.uk/~ripley/ > University of Oxford, Tel: +44 1865 272861 (self) > 1 South Parks Road, +44 1865 272866 (PA) > Oxford OX1 3TG, UK Fax: +44 1865 272595 _________________________________________________________________ Your Future Starts Here. Dream it? Then be it! Find it at www.seek.com.au %2F%3Ftracking%3Dsk%3Ahet%3Ask%3Anine%3A0%3Ahot%3Atext&_t=764565661&_r=OCT07_endtext_Future&_m=EXT [[alternative HTML version deleted]] ______________________________________________ R-help@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.
