On Mar 4, 2010, at 12:50 PM, jonas garcia wrote:
> Thank you so much for your reply.
>
> I can identify the characters very easily in a couple of files. The
> reason I am worried is that I have thousands of files to read in.
> The files were produced in a very old MS-DOS software that records
> information on oceanographic data and geographic position during a
> survey.
>
> My main goal is read all these files into R for further analysis.
> Most of the files are cleared of these EOL markers but some are not.
> I only noticed the problem by chance when I was looking and
> comparing one of them. I wonder if I can solve this problem using R,
> without having to go for text editors separately.
I could not "see" the character you pasted, so maybe others were
similarly "in the dark" or "under water" as might be a more
appropriate analogy here. Can you look at the character with a hex-
editor or translate it to a character code so that better minds than
mine might be able to comment on what sort of weirdness might have
been introduced and how it could be scanned?
--
David.
>
> Help on this would be much appreciated.
> Thanks again
>
> J
>
>
> On 3/4/10, David Winsemius <dwinsem...@comcast.net> wrote:
>
> 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@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
>
>
David Winsemius, MD
Heritage Laboratories
West Hartford, CT
[[alternative HTML version deleted]]
______________________________________________
R-help@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.
