[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