


Dear,

When I try to to execute the following command, R don't read all lines (reads only 57658 lines when the file has 814125 lines):

 

dados2<-read.table("C:\\Documents and Settings\\mgoncalves\\Desktop\\Tábua IFPD\\200701_02_03_04\\SegurosClube.txt",header=FALSE,sep="^",colClasses=c("character","character","NULL",NA,"NULL","NULL","NULL","character","character","NULL","NULL","NULL","NULL",NA,"NULL","NULL","NULL","NULL",NA,"NULL","NULL"),quote="",comment.char="",skip=1,fill=TRUE)
 
If I exclude "fill=TRUE", R gives the message 

 

Warning message:
In scan(file, what, nmax, sep, dec, quote, skip, nlines, na.strings,  :
  número de itens não é múltiplo do número de colunas (number of itens is not multiple of number of columns)

 

I identified that the problem is the following line of my data (line 57659 of my file):

 

13850074571^01/01/1940^00000000000^93101104^^^1^01/05/2006^30/06/2006^13479^13479^13479^0^0^0^0^^66214-Previdência privada fechada^MARIA^DA CONCEI`O FERREIRA LOBATO^CORPORATE


As you can observe, my data have a "square" string like this:  (i don't know if you can see the character, but it looks like a white square). It looks like that R understands this character as the end of the archive.

I opened my data on the notepad and copied the character. When I paste this character on R, it try to close asking if I want to save my work. What is happenning?

 

Thanks very much.

Marcelo Estácio

 		 	   		  
	[[alternative HTML version deleted]]

