I'm trying to read in some data from a .csv format and have come across
the following issue. Here is a simple example for replication
# A sample .csv format
schid,sch_name
331-802-7081,School One
464-551-7357,School Two
388-517-7627,School Three \& Four
388-517-4394,School Five
Note the third line includes the \ character. However, when I read the
data in I get
> read.csv(file.choose())
schid sch_name
1 331-802-7081 School One
2 464-551-7357 School Two
3 388-517-7627 School Three & Four
4 388-517-4394 School Five
It turns out to be very important to read in this character as I have a
program that loops through a data set and Sweave's about 30,000 files.
The variable sch_name gets dropped into the tex file using
\Sexpr{tmp$sch_name}. However, if there is an &, the latex file won't
compile properly. So, what I need is for the data to be read in as
schid sch_name
1 331-802-7081 School One
2 464-551-7357 School Two
3 388-517-7627 School Three \& Four
4 388-517-4394 School Five
I am obligated by a client to include the & in the school name, so
eliminating that isn't an option. I thought maybe comment.char or quote
would be what I needed, but they didn't resolve the issue. I'm certain
I'm missing something simple, I just can't see it.
Any thoughts?
Harold
[[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.
