more efficient way of coding a series of string variables which contain a fix subset of strings
1 view (last 30 days)
Show older comments
Dear all,
I have the following list
l1= 'di _Aust.xlsx' ;
l2='di _Bel.xlsx' ;
l3='di_Est.xlsx';
l4 = 'di_Fr.xlsx';
l5 = 'di_Ge.xlsx' ;
l6 = 'di_Gre.xlsx';
l7 = 'di_Ire.xlsx' ;
l8 = 'di_Ita.xlsx' ;
l9 = 'di_Nethe.xlsx';
l10 ='di_Portu.xlsx' ;
l11 ='di_Slova.xlsx' ;
l12= 'di_Sloven.xlsx';
l13= 'di_Spa.xlsx' ;
As you can see in any case the only part that changes is “di”. I was wondering if there is a more efficient way of writing this number of lists
For instance,
Kk={‘di’ ‘rt’ ‘ew’ }
And if I have, for example kk(2), then to get the output
l1= 'rt _Aust.xlsx' ;
l2='rt _Bel.xlsx' ;
l3='rt_Est.xlsx';
and so forth
0 Comments
Accepted Answer
Thomas
on 5 Jul 2012
IS this what you need?
kk={'di' 'rt' 'ew' };
name={'Aust' 'Bel' 'Est' 'Fr'};
for ii=1:length(name)
l=strcat(kk(1),'_',name(ii))
% xlswrite(l , data) % here you have your xlswrite
end
More Answers (1)
Mark Whirdy
on 5 Jul 2012
Hi Looks like a case for regexp(), but for a more detailed solution I'll need you to reword your question as its difficult to understand exactly what variables you have and the code-behaviour you need.
See Also
Categories
Find more on Startup and Shutdown in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!