[R] Embedded carriage returns in text document
Augusto.Sanabria at ga.gov.au
Augusto.Sanabria at ga.gov.au
Tue Nov 14 05:06:57 CET 2006
Dennis,
You can get rid of the '^M' by reformating the
file from DOS to UNIX. Withing a UNIX system
send the command
> dos2unix filename1 filename2.
Filename2 won't have the '^M'.
Hope it helps,
Augusto
--------------------------------------------
Augusto Sanabria. MSc, PhD.
Mathematical Modeller
Risk Research Group
Geospatial & Earth Monitoring Division
Geoscience Australia (www.ga.gov.au)
Cnr. Jerrabomberra Av. & Hindmarsh Dr.
Symonston ACT 2601
Ph. (02) 6249-9155
-----Original Message-----
From: r-help-bounces at stat.math.ethz.ch
[mailto:r-help-bounces at stat.math.ethz.ch] On Behalf Of Dennis Fisher
Sent: Tuesday, 14 November 2006 9:06
To: r-help at stat.math.ethz.ch
Subject: [R] Embedded carriage returns in text document
Colleagues,
I am using R 2.4.0 on both a Mac (10.4.8) and Linux (RedHat 9). To
read data from an Excel spreadsheet, I do "save as" in Excel, then
select the "Text (tab-delimited)" format. The resulting file uses a
tab separator and I can usually read the file using read.delim.
Sometimes, the header row contains embedded carriage returns. When I
view the file, these carriage returns appear as "^M".
Now the problem:
When I read.delim these files, they do not read correctly. Sometimes
I get error messages; sometimes only the first line is read.
Interestingly, invoking the option skip=1 (or a larger N) does not
appear to bypass the problem.
I can solve the problem by manually deleting these carriage returns
either in the original Excel file or the .txt version. However,
this is not an ideal solution.
Does anyone have a work-around within R?
Dennis
Dennis Fisher MD
P < (The "P Less Than" Company)
Phone: 1-866-PLessThan (1-866-753-7784)
Fax: 1-415-564-2220
www.PLessThan.com
[[alternative HTML version deleted]]
______________________________________________
R-help at stat.math.ethz.ch 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.
More information about the R-help
mailing list