Data Manipulation

Thank you Dieter, 

but i  still have a problem to write to file. The problem is the slash in
file names (Aerospace/Defense Products & Services ). If i want  it to C:/ab/
so "C:/ab/AdvertisingAgencies.txt" is ok but
"C:/ab/Aerospace/Defense-MajorDiversified.txt" is not

head(AlexETF)

AlexETF.Industry         AlexETF.Ticker
1    Scientific & Technical Instruments                     A
2                              Aluminum                           AA
3                     Business Services                       AAC
4                       Credit Services                       AACC
5                     Regional Airlines                          AAI
6 Aerospace/Defense Products & Services             AAII

by(AlexETF,AlexETF$Industry,function(a) {filename = paste(gsub("
","",a$Industry[1]),".txt",sep="")

+      print(filename)
+      
+    }
+ ) 
[1] "Accident&HealthInsurance.txt"
[1] "AdvertisingAgencies.txt"
[1] "Aerospace/Defense-MajorDiversified.txt"
[1] "Aerospace/DefenseProducts&Services.txt"
[1] "AgriculturalChemicals.txt"
[1] "AirDelivery&FreightServices.txt"

by(AlexETF,AlexETF$Industry,function(a) {filename = paste("C:/ab/",gsub("
","",a$Industry[1]),".txt",sep="")

+      write.table(a,file=filename,col.names = FALSE)     
+    }
+ ) 
Error in file(file, ifelse(append, "a", "w")) : 
  cannot open the connection
In addition: Warning message:
In file(file, ifelse(append, "a", "w")) :
  cannot open file 'C:/ab/Aerospace/Defense-MajorDiversified.txt': No such
file or directory



Thanks in advance,

Peter

View this message in context: http://n4.nabble.com/Data-Manipulation-tp1018249p1032029.html
Sent from the R help mailing list archive at Nabble.com.