Yep, you're right.
Jim
On Tue, Jul 2, 2019 at 7:52 AM William Dunlap <wdun...@tibco.com> wrote:
>
> 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.
______________________________________________
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.
