[R] write.csv +RMySQL request

jim holtman jholtman at gmail.com
Fri Feb 29 02:43:15 CET 2008


?capture.output

myoutput <- capture.output(write.csv(...))

On Thu, Feb 28, 2008 at 7:34 PM, Tristan Casey <nub_vulcanis at hotmail.com> 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!
>
>
>
> _________________________________________________________________
>
>
> e%2Ecom%2Fcgi%2Dbin%2Fa%2Fci%5F450304%2Fet%5F2%2Fcg%5F801459%2Fpi%5F1004813%2Fai%5F859641&_t=762955845&_r=tig_OCT07&_m=EXT
>        [[alternative HTML version deleted]]
>
> ______________________________________________
> R-help at 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.
>



-- 
Jim Holtman
Cincinnati, OH
+1 513 646 9390

What is the problem you are trying to solve?  Tell me what you want to
do, not how you want to do it.



More information about the R-help mailing list