[R] data import: strange experience
jwd
jwd at surewest.net
Fri Aug 23 01:33:28 CEST 2013
On Wed, 21 Aug 2013 10:35:53 -0400
SH <emptican at gmail.com> wrote:
It looks like your problem has already been answered, however, as a
rule of thumb anytime you see a peculiarity like this you should look
for minor variations between what you expected to export and what Excel
really exported as delimited text. Occasionally there will be a
space or other character (",'/$,- etc.) that maybe handled as
a signal or ignored by the importing program but not by Excel. Usually
Excel works as expected, but it is a good idea to examine the text
file(s) in an editor like notepad in Windows or Kate in Linux if you
encounter an oddity. BTW, there better choices than notepad for Windows
and I would recommend one with column selecting abilities for work on
delimited data files.
jwdougherty
More information about the R-help
mailing list