On 3/26/2013 7:21 AM, Kerry wrote: > Thank you Jason! actually, there have been two solutions and one is yours > > setting row.names=F works great, additionally what Ive been having problems > with is the European version of Word 2010. Apparently it sets delimiters of > ";" instead of "," as in the English/USA version. This is something that > messes not only with R exporting txt or csv files, but will effect Office > products, ArcGIS and several more. So having to go into the Region and > Language settings of the computer and changing the defaults has cleared up > quite a bit of the issues I was having with R. > > ~K ?read.csv2 This is a wrapper to read.table(). read.csv2 expects the delimiter to be ';" by default and the decimal to be "," by default. > > > Not all who wander are lost > K. L. Nicholson PhD > Associate Wildlife Biologist® > > > > > ________________________________ > From: "Law, Jason" <jason....@portlandoregon.gov> > > > Sent: Tuesday, March 5, 2013 5:31 PM > Subject: RE: R-help Digest, Vol 121, Issue 5 > > On R 2.15.2 and ArcGIS 9.3.1, it works for me in ArcCatalog but you have to > follow the particulars here: > > http://webhelp.esri.com/arcgisdesktop/9.3/index.cfm?TopicName=Accessing_delimited_text_file_data > > For example: > > write.table(test, '***.tab', sep = '\t', row.names = F) > > The extension .tab and sep = '\t' are required for text files. Didn't test > row.names=T but I wouldn't count on that working either. > > Jason Law > Statistician > City of Portland, Bureau of Environmental Services > Water Pollution Control Laboratory > 6543 N Burlington Avenue > Portland, OR 97203-5452 > 503-823-1038 > jason....@portlandoregon.gov > > -----Original Message----- > Date: Mon, 04 Mar 2013 10:48:39 -0500 > From: Duncan Murdoch <murdoch.dun...@gmail.com> > > Cc: "r-help@r-project.org" <r-help@r-project.org> > Subject: Re: [R] Mysterious issues with reading text files from R in > ArcGIS and Excel > Message-ID: <5134c257.6020...@gmail.com> > Content-Type: text/plain; charset=ISO-8859-1; format=flowed > > On 04/03/2013 10:09 AM, Kerry wrote: >> It seems within the last ~3 months Ive been having issues with writing text >> or csv files from a R data frame. The problem is multifold and it is hard >> to filter out what is going on and where the problem is. So, Im hoping >> someone else has come across this and may provide insight. > I think you need to provide a simple example for us to try, either by > putting a small example of one of your files online for us to download, > or (better) by giving us self-contained code to duplicate the problem. > > You might also get better help (especially about ArcGIS) on the > R-sig-Geo mailing list: <https://stat.ethz.ch/mailman/listinfo/r-sig-geo>. > > Duncan Murdoch > >> >> >> My current settings for R: >> R version 2.15.2 (2012-10-26) >> Platform: x86_64-w64-mingw32/x64 (64-bit) >> locale: >> >> [1] LC_COLLATE=Swedish_Sweden.1252 LC_CTYPE=Swedish_Sweden.1252 >> LC_MONETARY=Swedish_Sweden.1252 LC_NUMERIC=C >> [5] LC_TIME=Swedish_Sweden.1252 >> >> attached base packages: >> [1] tcltk stats graphics grDevices utils datasets methods >> base >> >> other attached packages: >> [1] adehabitat_1.8.11 shapefiles_0.6 foreign_0.8-51 tkrplot_0.0-23 >> ade4_1.5-1 >> >> loaded via a namespace (and not attached): >> [1] tools_2.15.2 >> >> I am using Microsoft Excel 2010 and ArcGIS 10.1sp1 for Desktop >> >> Basically, no matter what data frame I am working on, when I export it to a >> text file to be use in Excel or ArcGIS problems arise. Im not sure if it is >> R or these other programs, maybe forums for ArcGIS might be more >> appropriate, but this problem only occurs when I use tables that have been >> produced from an R session. >> >> When I try to open a text file in Excel, either I get an error message >> stating >> The file you are trying to open is in a different format than specified by >> the file extension. Verify that the file is not corrupted and is from a >> trusted source. >> Followed by >> Excel has detected that 'file.txt' is a SYLK file, but cannot load it. >> Either the file has errors or is not a SYLK file format. Click OK to open >> the file in a different format >> Then the file opens >> >> >> Otherwise, the file opens "fine" the first time through - and "looks" ok. I >> can't figure out what Im doing different between the two commands of >> write.table as they are always written the same: >> write.csv(file, file = "D:/mylocations/fileofinterest.csv") or >> write.table(file, file = "D:/mylocations/fileofinterest.txt") >> Sometimes I will try to add sep = "," or sep = ";" but these don't make a >> difference (which I didn't figure they would). >> >> The other program I use is ArcGIS and bringing in a txt file from R is >> really messing things up as 2 new columns of information are typically added >> and date/time data is usually lost with txt files, but not with csv files. >> >> For instance - a text file that looks like this in Excel: >> id x y date R1dmed R1dmean R1error >> R2error >> 1 F07001 1482445 6621768 2007-03-05 10:00:53 2498.2973 2498.2973 FALSE >> FALSE >> 2 F07001 1481274 6619628 2007-03-05 12:00:41 657.1029 657.1029 FALSE >> FALSE >> 3 F07001 1481279 6619630 2007-03-05 14:01:12 660.3569 660.3569 FALSE >> FALSE >> 4 F07001 1481271 6619700 2007-03-05 16:00:39 620.1397 620.1397 FALSE >> FALSE >> >> in ArcGIS now looks like this: >> >> Field1idid_Xid_YxydateR1dmedR1dmean R1errorR2errorOBJECTID * >> 1F07001118.0818119.485541e+01514824456621768NA2498.297272498.29727FALSEFALSE1 >> 2F07001118.0818119.485541e+01514812746619628NA657.102922657.102922FALSEFALSE2 >> 3F07001118.0818119.485541e+01514812796619630NA660.356911660.356911FALSEFALSE3 >> 4F07001118.0818119.485541e+01514812716619700NA620.139702620.139702FALSEFALSE4 >> 5F07001118.0818119.485541e+01514808496620321NA378.186792378.186792FALSEFALSE5 >> >> Where did id_X and id_Y come from?? What are they?? >> What happened to the Date column??? Why does the date column show up when I >> use write.csv but not write.table? >> >> Thank you for your help. >> >> ~K >> [[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. > [[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.
-- Robert W. Baer, Ph.D. Professor of Physiology Kirksille College of Osteopathic Medicine A. T. Still University of Health Sciences Kirksville, MO 63501 USA [[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.