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]]

______________________________________________
[email protected] 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.

Reply via email to