R help - Mar 2010 - End of line marker?

Dear R users,

I am trying to read a huge file in R. For some reason, only a part of the
file is read. When I further investigated, I found that in one of my
non-numeric columns, there is one odd character responsible for this, which
I reproduce bellow:

In case you cannot see it, it looks like a right arrow, but it is not the
one you get from microsoft word in menu "insert symbol".

I think my dat file is broken and that funny character is an EOL marker that
makes R not read the rest of the file. I am sure the character is there by
chance but I fear that it might be present in some other big files I have to
work with as well. So, is there any clever way to remove this inconvenient
character in R avoiding having to edit the file in notepad and remove it
manually?

 Code I am using:

read.csv("new3.dat", header=F)

Warning message:
In read.table(file = file, header = header, sep = sep, quote = quote,  :
  incomplete final line found by readTableHeader on 'new3.dat'

I am working with R 2.10.1 in windows XP.

Thanks in advance

Jonas

	[[alternative HTML version deleted]]

On Mar 3, 2010, at 2:22 PM, jonas garcia wrote:
> Dear R users,
>
> I am trying to read a huge file in R. For some reason, only a part  
> of the
> file is read. When I further investigated, I found that in one of my
> non-numeric columns, there is one odd character responsible for  
> this, which
> I reproduce bellow:
> 
> In case you cannot see it, it looks like a right arrow, but it is  
> not the
> one you get from microsoft word in menu "insert symbol".
>
> I think my dat file is broken and that funny character is an EOL  
> marker that
> makes R not read the rest of the file. I am sure the character is  
> there by
> chance but I fear that it might be present in some other big files I  
> have to
> work with as well. So, is there any clever way to remove this  
> inconvenient
> character in R avoiding having to edit the file in notepad and  
> remove it
> manually?
>
> Code I am using:
>
> read.csv("new3.dat", header=F)
>
> Warning message:
> In read.table(file = file, header = header, sep = sep, quote =  
> quote,  :
>  incomplete final line found by readTableHeader on 'new3.dat'
I think you should identify the offending line by using the  
count.fields function and fix it with an editor.


-- 
David
>
> I am working with R 2.10.1 in windows XP.
>
> Thanks in advance
>
> Jonas
>
> 	[[alternative HTML version deleted]]
>
> ______________________________________________
> R-help at r-project.org 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.
David Winsemius, MD
Heritage Laboratories
West Hartford, CT