Should that encoding="UTF-8" be encoding="UTF-16"?
Bill Dunlap
TIBCO Software
wdunlap tibco.com
On Mon, Jul 1, 2019 at 2:45 PM Jim Lemon <drjimle...@gmail.com> wrote:
> Hi Javad,
> Unicode characters do have embedded nulls. Try this:
>
> d4<-read.table("./4.csv",sep=";",header=TRUE,encoding="UTF-8")
>
> Jim
>
> On Tue, Jul 2, 2019 at 3:47 AM javad bayat <j.bayat...@gmail.com> wrote:
> >
> > Dear R users;
> > I am trying to read an excel CSV file (1.csv). When I read it as csv file
> > in R, the R shows me the exact number of row. But it puts all columns in
> > one column, while I have 3 or 4 columns in the data frame.
> > "
> > d4 = read.table("./4.csv",sep=";",header=TRUE)
> > Warning messages:
> > 1: In read.table("./4.csv", sep = ";", header = TRUE) :
> > line 1 appears to contain embedded nulls
> > 2: In read.table("./4.csv", sep = ";", header = TRUE) :
> > line 2 appears to contain embedded nulls
> > 3: In read.table("./4.csv", sep = ";", header = TRUE) :
> > line 3 appears to contain embedded nulls
> > 4: In read.table("./4.csv", sep = ";", header = TRUE) :
> > line 4 appears to contain embedded nulls
> > 5: In read.table("./4.csv", sep = ";", header = TRUE) :
> > line 5 appears to contain embedded nulls
> > 6: In read.table("./4.csv", sep = ";", header = TRUE) :
> > line 1 appears to contain embedded nulls
> > 7: In scan(file = file, what = what, sep = sep, quote = quote, dec =
> > dec, :
> > embedded nul(s) found in input
> > > attach(d4)
> > > dim(d4)
> > [1] 1814394 1
> > "
> > I opened the csv file in excel and I tried to make a new csv (delimited)
> > file. I dont know why in the "save as type" box Unicode text (*.txt) is
> > written. Why the format is txt while the file extension is .CSV?
> > Please help me to read this format correctly.
> > Many thanks.
> >
> >
> >
> > --
> > Best Regards
> > Javad Bayat
> > M.Sc. Environment Engineering
> > Alternative Mail: bayat...@yahoo.com
> >
> > [[alternative HTML version deleted]]
> >
> > ______________________________________________
> > 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.
>
[[alternative HTML version deleted]]
______________________________________________
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.
