specific text to excel

I have several text files with diffrent file name, and I need to extract specific data from those text file and record it in excel. The sample text file is below. In each text file there are 1000 collapse multiplier value and they are both positive and negative values. I have to extract this 1000 data from multiple text file and record in a excel file. Each text file have 1000 data, so for 5 text file I need 5 columsns in excel. Please help to solve it.

Answer 1

[Walter Roberson]

filenames = {'T3.txt', 'shortrun.txt', 'scarecrow.txt', 'longrun.txt', 'T3b.txt'};
outfile = 'collapse.xlsx';
colnames = 'A':'Z';   %needs fixing if you have more than 26

for K = 1 : length(filenames)
   thisfile = filenames{K};
   S = fileread(thisfile);
   collapses = str2double(regexp(S, '(?<=COLLAPSE MULTIPLIER =\s+)\S+', 'match'));
   writematrix(collapses(:), outfile, 'range', colnames(K));
end

[Bishal Chudal]

This code is not working

[Image Analyst]

@Bishal Chudal, here is another chance to read the posting guidelines that you overlooked:

TUTORIAL: How to ask a question (on Answers) and get a fast answer

Or click the Community Guidelines link below.

AFTER you do that, attach two text files so people can help you easier by using your actual data. And explain in more detail what "not working" means by showing error messages, output files, or whatever.

[Walter Roberson]

If we are going to play "20 Questions" for me to try to figure out what you are observing, then tradition demands that you tell me whether what you are thinking of is Animal, Vegetable, or Mineral.

[Walter Roberson]

You did not tell me what your file names are. You did not tell me what pattern they follow.

You supplied a picture of an input file, not an actual input file, so I cannot test my code.

The picture you supplied only shows a part of one occurance, not even one full cycle.

You did not give me any information about what difficulty you observed in running the code.

You did not mark which MATLAB release you are using, so possibly my code would have been fine in a release later than yours.

You need to give us more to go on then just "This code is not working". At least one input file would help.

[Bishal Chudal]

I have attached an input files, please help me to go trough it. I want those 1000 data from each input file in an excel sheet. Thanks

[Walter Roberson]

Tested. Finishes in a small number of seconds.

I took the liberty of putting the file name as the column header.

dinfo = dir('*.txt');
filenames = {dinfo.name};

outfile = 'collapse.xlsx';
colnames = 'A':'Z';   %needs fixing if you have more than 26

for K = 1 : length(filenames)   
  thisfile = filenames{K};
   [~, basename] = fileparts(thisfile);
   S = fileread(thisfile);
   CM = regexp(S, '^(COLLAPSE MULTIPLIER =\s+)(?<CM>\S+)', 'names', 'lineanchors');
   collapses = [basename, num2cell(str2double({CM.CM}))].';
   writecell(collapses, outfile, 'range', colnames(K) + "1");
end