How to read .bnn.lis file (ascii file) for the specific data

Dear Experts,

I want to read the values inside orange line as an array.

file name is " SCINTILLAORS STACK WITH CHAMBER-1_21.bnn.lis " which looks like in the image (file is attached which I can open in with .txt format as i couldn't attach the original .bnn.lis file).

I tried the following method but it is not giving the desired terms

filename='SCINTILLAORS STACK WITH CHAMBER-1_21.bnn.lis';

fileid=fopen(filename);

c=textscan(fileid,'%f %f %f %f %f %f %f %f %f %f %f %f %f %f %f');

fclose(fileid);

whos c

Please, help me take out the values inside the orange line

Thank you

Answer 1

[Mathieu NOE]

hello

this is one possibility :

lines = readlines('SCINTILLAORS STACK WITH CHAMBER-1_21.txt');

%% main code 
nn = find(contains(lines,'accurate deposition along the tracks requested')); % find the line number of this text
lines_to_read = 2;  % read the 2 lines after line containing above text

for ck = 1:lines_to_read
    tmp = (str2double(split(lines(nn+ck))))';
    tmp(isnan(tmp)) = []; % remove NaNs
    out{ck,1} = tmp;  % store in cell array
end

% export to txt
writecell(out,'output.txt',"Delimiter","\t");

[SHUBHAM AGARWAL]

Dear Mathieu NOE,

Thank you very much for quick respose. This method helps me. However , I have two more questions regarding this

1. I want to put the second line inside orange line in the end of first line as an array. How can it be done?

2. I also have a lot of similar files (with different serial numbers) which needed to be manipulate. How can I use For loop to create different output files of different input files?

I tried to use

p = dir('*.bnn.lis');

for i=1:numel(p)

lines=readlines(p(i).name);

But It is giving only one output file.

Thank you

[Mathieu NOE]

hello again

the answer for the 1st topic is quite easy

this will put the two input lines in one output line :

lines = readlines('SCINTILLAORS STACK WITH CHAMBER-1_21.txt');

% main code 
nn = find(contains(lines,'accurate deposition along the tracks requested')); % find the line number of this text
lines_to_read = 2;  % read 2 lines after line containing above text
out = [];

for ck = 1:lines_to_read
    tmp = (str2double(split(lines(nn+ck))))';
    tmp(isnan(tmp)) = []; % remove NaNs
    out = [out tmp];
end

% export 
writematrix(out,'output.txt',"Delimiter","\t");

for the loop , give me a few minutes more

[Mathieu NOE]

here with the for loop

FYI, to make sure files listed from directory are sorted correctly (what DIR does not always do well) I use this excellent tool available from FEX :

Natural-Order Filename Sort - File Exchange - MATLAB Central (mathworks.com)

code :

fileDir = pwd;

%% main code 

S = dir(fullfile(fileDir,'SCINTILLAORS*.txt')); % get list of data files in directory
S = natsortfiles(S); % sort file names into natural order , see : 
           %(https://fr.mathworks.com/matlabcentral/fileexchange/47434-natural-order-filename-sort)
           
for k = 1:length(S)
    
    filename = fullfile(fileDir, S(k).name);
    filename_out = [filename(1:length(filename)-4) '_out.txt'];
    
    % do the data processing
    lines = readlines(filename);

    nn = find(contains(lines,'accurate deposition along the tracks requested')); % find the line number of this text
    lines_to_read = 2;  % read 2 lines after line containing above text
    out = [];

    for ck = 1:lines_to_read
        tmp = (str2double(split(lines(nn+ck))))';
        tmp(isnan(tmp)) = []; % remove NaNs
        out = [out tmp];
    end
    
    % export 
    writematrix(out,filename_out,"Delimiter","\t");
   
      
end

[SHUBHAM AGARWAL]

Dear Mathieu,

Thank you very much. You are a great help and teacher.

[Mathieu NOE]

My pleasure !!