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
Not all who wander are lost
K. L. Nicholson PhD
Associate Wildlife Biologist®
________________________________
From: "Law, Jason" <Jason.Law@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.law@portlandoregon.gov
-----Original Message-----
Date: Mon, 04 Mar 2013 10:48:39 -0500
From: Duncan Murdoch <murdoch.duncan@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.6020000@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]]