I would remove the quotes using sub, something like
# Read the file as text lines
text = readLines(con = file(yourFileName))
# Remove the offending quotes
text = gsub("'|\"", "", text)
# Concatenate and turn into a data frame
concat = paste(text, collapse = "\n")
df = read.table(text = concat, ...) # Change arguments as needed
HTH,
Peter
On Thu, Aug 8, 2019 at 5:41 PM Val <valkr...@gmail.com> wrote:
>
> Thank you all, I can read the text file but the problem was there is
> a single quote embedded in the first row of second column. This
> quote causes the problem
>
> vld<-read.table(text="name prof
> A '4.5
> B "3.2
> C 5.5 ",header=TRUE)
>
> On Thu, Aug 8, 2019 at 7:24 PM Anaanthan Pillai
> <anaanthanpil...@gmail.com> wrote:
> >
> > data <- read.table(header=TRUE, text='
> > name prof
> > A 4.5
> > B 3.2
> > C 5.5
> > ')
> > > On 9 Aug 2019, at 8:11 AM, Val <valkr...@gmail.com> wrote:
> > >
> > > Hi all,
> > >
> > > I am trying to red data where single and double quotes are embedded
> > > in some of the fields and prevented to read the data. As an example
> > > please see below.
> > >
> > > vld<-read.table(text="name prof
> > > A '4.5
> > > B "3.2
> > > C 5.5 ",header=TRUE)
> > >
> > > Error in read.table(text = "name prof \n A '4.5 \n B
> > > 3.2 \n C 5.5 ", :
> > > incomplete final line found by readTableHeader on 'text'
> > >
> > > Is there a way how to read this data and gt the following output
> > > name prof
> > > 1 A 4.5
> > > 2 B 3.2
> > > 3 C 5.5
> > >
> > > Thank you inadvertence
> > >
> > > ______________________________________________
> > > R-help@r-project.org mailing list -- To UNSUBSCRIBE and more, see
> > > 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.
> >
>
> ______________________________________________
> R-help@r-project.org mailing list -- To UNSUBSCRIBE and more, see
> 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.
______________________________________________
R-help@r-project.org mailing list -- To UNSUBSCRIBE and more, see
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.
