For loop in string array

Hello Matlab Community,

How can I loop though my string array to get indexes? Here is my code using for loop but it creates blank matix after running a for loop.

str = importfile("imageTimeline1.xlsx");

% individual data collection
Ind_1_start = find(contains(str,'Stimulus 1 Data'));
Ind_1_end = find(contains(str,'Questionnair 1 Data'));

Ind_2_start = find(contains(str,'Stimulus 2 Data'));
Ind_2_end = find(contains(str,'Questionnair 2 Data'));

% using for loop to collect index information
for ii = 1:20
    Ind_start{:,ii} = find(contains(str,['Stimulus' num2str(ii) 'Data']));
    Ind_end{:,ii} = find(contains(str,['Questionnair' num2str(ii) 'Data']));
end

Thank you,

Aakash.

Answer 1

[Walter Roberson]

 ['Stimulus' num2str(ii) 'Data']

that does not generate spaces between the word and the number.

I suggest that you use sprintf()

[Aakash Soni]

Thank you for pointing out space issue in my array.

I found following code works fine for my application:

for ii = 1:20
    Ind_start(ii,:) = find(contains(str,['Stimulus' ' ' num2str(ii) ' ' 'Data']));
    Ind_end(ii,:) = find(contains(str,['Questionnair' ' ' num2str(ii) ' ' 'Data']));
end