Getting error when reading tab demilited file: "EOF within quoted string"

Question

I am trying to read a tab delimited file in R and getting following error. I have more than 2 million records in file but its extracting only 1.2 million records.

Warning message: In scan(file, what, nmax, sep, dec, quote, skip, nlines, na.strings, : EOF within quoted string

score 2 · Answer 1 · edited May 23 '17 at 11:52

As you indicate yourself the problem lies in the fact that ' are recognized as quotes, and this will cause R to interpret anything between this and the next quotation mark as on character string. See also here for a longer explanation. The easy solution is to disable quoting altogether using quote = "".

For future reference, please check earlier posts first, since the same solution was given in this SO post.

score 0 · Answer 2 · answered Apr 27 '16 at 18:53

0

I read the file in notepad++ and it was reading it correctly. Finally, I tried removing all prime symbols (') from the text file using notepad++ and it worked for me.

answered Apr 27 '16 at 18:53

Navdeep_DS

85
7

Getting error when reading tab demilited file: "EOF within quoted string"

2 Answers2