This example works fine:
test-matrix(c(1,2,'VOICIUNPETITTES',3),ncol=2,nrow=2)
write.csv(test,file='C:/xavier/test.csv')
Could you provide the same small example when it doesn't work?
kwaj wrote:
Hello,
I have a peculiar problem which I am hoping I can get help on.
I am using the write.csv command to write a matrix structure to a file,
which I later read in excel. The command works quite well for most strings
and numerical values in the matrix structure.
However, I have found that when a field in the matrix contains a string of
long length, when the matrix is finally written the file - the field shows
up as NA. I am assuming write.csv has a limit on the field size? Maybe
16 characters?
Assuming the above is correct - I tried to extract a portion of the string
using the 'substring' command and enter the extracted portion into the
field before using the write.csv command. However I find, that when a
string is extracted, the output from write.csv generates a NA in the file
output.
My questions are:
1) Does write.csv have a limit on the size of strings in the matrix
fields? Is there anyway to place large strings in the field?
2) Is there anyway to make the substring command or an alternative but
similar command, compatible with write.csv? I have tried
'as.character(substring(phrase, min, max)' and that does not seem to work
cheers
--
View this message in context:
http://www.nabble.com/write.csv---string-extraction-and-field-limits-tf4395535.html#a12596551
Sent from the R help mailing list archive at Nabble.com.
__
R-help@stat.math.ethz.ch 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.
