Re: [R] Data Manipulation

I still struggling with this: error massage: > by(AlexETF,AlexETF$Industry,function(a) {filename = paste("C:/ab/",gsub(" > ","",a$Industry[1]),".txt",sep="") + print(filename) + write.table(a[,3,drop=FALSE],quote=FALSE,col.names=FALSE,row.names=FALSE) + } + ) [1] "C:/ab/Acc

Re: [R] Data Manipulation

Thank you Don for the code, but I get the following error massage: > by(AlexETF,AlexETF$Industry,function(a) {filename = paste("C:/ab/",gsub(" > ","",a$Industry[1]),".txt",sep="") + print(filename) + write.table(a[,3,drop=FALSE],quote=FALSE,col.names=FALSE,row.names=FALSE) + }

Re: [R] Data Manipulation

Thank you Dieter and Rolf, I have solved the slash Problem, but I still struggling with the output files. I have tried this by(AlexETF,AlexETF$Industry,function(a) {filename = paste("C:/ab/",gsub(" ","",a$Industry[1]),".txt",sep="") print(filename) write.table(a,file=filename,c

Re: [R] Data Manipulation

by the way how do i change the output "1016" "Advertising Agencies" "CMM" "1803" "Advertising Agencies" "FMCN" "2427" "Advertising Agencies" "IPG" "3093" "Advertising Agencies" "MWW" "3372" "Advertising Agencies" "OMC" "4809" "Advertising Agencies" "VCLK" "4832" "Advertising Agencies" "VISN" "500

Re: [R] 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)

[R] Data Manipulation

Dear All, I would like to to group the Ticker by Industry and create file names from the Industry Factor and export to a txt file. I have tried the folowing ind=finvizAllexETF$Industry ind is then "Aluminum" "Business Services" "Regional Airlines" ind2=gsub(" " ,"",ind) ind3 [1]