Try changing encoding="UTF-16" to fileEncoding="UTF-16".
Bill Dunlap TIBCO Software wdunlap tibco.com On Mon, Jul 1, 2019 at 9:30 PM javad bayat <j.bayat...@gmail.com> wrote: > Dear all; > I use your suggestion but I gave the same warning messages. I changed the > file name (Data.csv). > " > d4<-read.csv("./Data.csv",sep=";",header=TRUE,encoding="UTF-16") > Warning messages: > 1: In read.table(file = file, header = header, sep = sep, quote = > quote, : > line 1 appears to contain embedded nulls > 2: In read.table(file = file, header = header, sep = sep, quote = > quote, : > line 2 appears to contain embedded nulls > 3: In read.table(file = file, header = header, sep = sep, quote = > quote, : > line 3 appears to contain embedded nulls > 4: In read.table(file = file, header = header, sep = sep, quote = > quote, : > line 4 appears to contain embedded nulls > 5: In read.table(file = file, header = header, sep = sep, quote = > quote, : > line 5 appears to contain embedded nulls > 6: In read.table(file = file, header = header, sep = sep, quote = > quote, : > 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 > " > > I opened the Data in notepad. This is the head of Data.csv. The columns > have been separated by semicolons. > " > "INLET Time";"INLET ValueY";"TRATED WATER TANK Time";"TRATED WATER TANK > ValueY" > 10/28/2018;550.057861328125;10/28/2018;487.812530517578 > 10/28/2018 12:00:01 ق.ظ;550.057861328125;10/28/2018 12:00:01 > ق.ظ;487.812530517578 > 10/28/2018 12:00:02 ق.ظ;550.057861328125;10/28/2018 12:00:02 > ق.ظ;487.812530517578 > 10/28/2018 12:00:03 ق.ظ;550.057861328125;10/28/2018 12:00:03 > ق.ظ;487.812530517578 > 10/28/2018 12:00:04 ق.ظ;550.057861328125;10/28/2018 12:00:04 > ق.ظ;487.812530517578 > . > . > . > " > Thanks. > > > > On Tue, Jul 2, 2019 at 6:14 AM Jeff Newmiller <jdnew...@dcn.davis.ca.us> > wrote: > > > Don't be so US-centric, Abby... how do you know that javad's version of > > Excel doesn't default to using semicolons? > > > > ?read.csv2 > > > > On July 1, 2019 6:06:32 PM PDT, Abby Spurdle <spurdl...@gmail.com> > wrote: > > >> 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) > > > > > >Firstly, I recommend against naming your file "1.csv". > > >(Start with a letter not a number). > > > > > >Secondly, a CSV file should be separated by commas not semicolons. > > >You can specify sep=",", however, it's probably easier to use the > > >read.csv() function. > > > > > >Note that you should be able to open your file in a text editor to see > > >the > > >separators. > > > > > >> I dont know why in the "save as type" box Unicode text (*.txt) > > > > > >Other posters have suggested that you need to specify the encoding. > > >Assuming that you create your CSV file correctly in Excel, I doubt that > > >this is necessary, but I could be wrong... > > > > > >Your comment suggests that you have saved your document as "Unicode > > >text". > > >You need to tell Excel to save the file as a CSV file. > > >(There should be a list of save options). > > > > > >Simply typing a file name with a .csv file extension is unlikely to > > >produce > > >the desired result. > > > > > > [[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. > > > > -- > > Sent from my phone. Please excuse my brevity. > > > > > -- > 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. > [[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.