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.