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.