[R] Carriage return character issue

[Jeff Newmiller]

No, but before you call that function you could use yourdataframe$lastcol <- gsub("\r$","",yourdataframe$lastcol)

"Steven Kang" <stochastickang at gmail.com> wrote:

>Hi all,
>
>I imported a file (in CSV format) into R for processing, then imported the
>result into MySQL. However, there are *carriage return* characters
>(hexadecimal: *0D*) that are appended to the characters in the last field of
>the table.
>
>i.e *\r* appended to the character values (as shown below)
>
>Before importing into MySQL: asdf
>
>After importing into MySQL: asdf*\r*
>**
>**
>
>Are there any options in the function "dbWriteTable" that may resolve this
>issue?
>
>Many thanks in advance.
>
>-- 
>Steven
>
>	[[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.

---------------------------------------------------------------------------
Jeff Newmiller                        The     .....       .....  Go Live...
DCN:<jdnewmil at dcn.davis.ca.us>        Basics: ##.#.       ##.#.  Live Go...
                                      Live:   OO#.. Dead: OO#..  Playing
Research Engineer (Solar/Batteries            O.O#.       #.O#.  with
/Software/Embedded Controllers)               .OO#.       .OO#.  rocks...1k
---------------------------------------------------------------------------
Sent from my phone. Please excuse my brevity.