storing test file here

just storing a file here

[KSSV]

What is your question?

[Allen Borrow]

data data dat a data

[Allen Borrow]

data data data data

[Jan]

@Allen Borrow: Please stop this immediately.

If all members use the forum to store anything, you will find only junk here soon.

Answer 1

[Arif Hoq]

if you are following this question you can try this code

https://www.mathworks.com/matlabcentral/answers/1657230-how-can-i-find-the-line-after-the-line-containing-the-text-i-am-looking-for?s_tid=srchtitle

A=readtable('Bookk.xlsx', 'ReadVariableNames', false);
B=table2cell(A)
% names = split(B,'delimiter',':')
r = strtok(B, ':')
R=[r B];
N=size(A,1);
C=cell(N,1);
for i=1:N
if isequal(R(i,1),{'1 x'})
    C{i}=[R(i,2);R(i+1,2);R(i+2,2)];
    if i==18
        break
    end
end
end
matrix=[C{:}]'  % if you want with x, y , z value
[token remain]=strtok(matrix,':')
output=strrep(remain,': ','') % if you want without x, y , z value

[Arif Hoq]

if you want to visibility also just concatenate here

C{i}=[R(i,2);R(i+1,2);R(i+2,2);R(i+3,2)];