[R] R import glitch "missing data"

[Struckmeier, Nathanael]

That is the strange thing... I DON'T get a warning message. R behaves as
if all data is being imported successfully. I don't receive a memory
warning, or warning of any kind. I've scanned my data for potential
problems and I do not have any ('). However...

The .txt version of my file does use (") around some of my dollar
values...here are all ways in which values on my .txt file are
expressed. 
900
-900
$900
"900"
"(900)"

The .csv version of my file uses:
900
-900
$900




StatBat2

-----Original Message-----
From: Peter Langfelder [mailto:peter.langfelder at gmail.com] 
Sent: Thursday, May 26, 2011 10:59 AM
To: Struckmeier, Nathanael
Cc: r-help at r-project.org
Subject: Re: [R] R import glitch "missing data"

On Thu, May 26, 2011 at 10:03 AM, StatBat2
<NStruckmeier at harryanddavid.com> wrote:
> Hello!
>
> I am trying import data into R and im running into a snag.
>
> GOAL:
> Import a 4 column, 8,000 row table into R including headers.
>
> WHAT I'VE ATTEMPTED:
> Original data was in Excel format.
> Converted data to both a .txt and .csv (to see which worked better)
> Imported data into R via commands as object "demand" (see below)
>
> Please excuse the long file path.
> demand=read.delim("C:\\Documents and Settings\\E066582\\My
> Documents\\R\\R-2.13.0\\bin\\demand.txt")
>
> demand=read.csv(("C:\\Documents and Settings\\E066582\\My
> Documents\\R\\R-2.13.0\\bin\\demand.csv", header=True)
>
> In both cases, about half to three fourths of my data shows up as
object
> "demand". My headers also fail to appear. I get about 4000 lines of my
table
> as well as missing headers. I've tried different variations on the
synatx of
> how i go about importing, with or without headers designated, with or
> without .csv ',' designation, but nothing changes. I'm at a loss as to
what
> is incorrect.

Do you  get any error or warning messages?

Are there any apostrophes (') in your data? These can cause mayhem. If
you have any, use the argument
quote = "\"".

HTH,

Peter