extracting specific data from extra large text file( a part of it is attached) into an array in the format mentioned in the attached excel

Hi,

Seeking for help in extracting data from a very big text file( a part of it is attached) into an array of format mentioned in the attached excel. Basically, trying to extract data between two strings ---Tx RF verify Measurement Results--- and ---Performing Tx RF verify ended--- into an array as per the format attached in the excel.

[per isakson]

Isn't this question essentially the same as your last question? Didn't the answers to that solve your problem?

"very big text file" How big is that compared to your RAM memory?

More or less every second column contains labels to the column to the right? Would it be enough to read the numbers? Which column can be skipped?

What about the time in the firts column?

[N/A]

No, it didnt solve.

Its around 1.32MB

Yes, it is enough to read numbers but few values doesnt have labels. For ex, Not CA and 50RB_Full. So, for those of which doesnt have labels but need those data(I mean if it is mentioned in excel) then you can assign any random name.Columns that are not mentioned in the excel can be skipped.

You can ignore time as you can see in excel attached, it doesnt have time anywhere.

[per isakson]

What about this mess at the very right of the table?

Limits	22	to	24	[dBm]	Passed
Limit	        6	[%]	Passed
Limit	        30	[%]	Passed
Limits	22	to	24	[dBm]	Passed
Limit	        6	[%]	Passed
Limit	        30	[%]	Passed

I failed to open the Excel file.

[N/A]

Those are the limits for values on the left. If the values falls within that limit then it is passed.

Not sure why you are unable to open the excel.

[per isakson]

This might be a first step

%%
fid = fopen('example.txt');
%                            1 2 3 4 5 6 7 8 9 0 1 2 3 4 5 6 7 8 9
cac = textscan( fid, '%*s%*s%s%d%s%d%s%s%f%s%f%s%s%d%s%s%s%s%s%f%[^\r\n]'  ...
            , 'Headerlines',2, 'Delimiter','\t', 'MultipleDelimsAsOne',false );
fclose( fid );

It reads three lines too many, thus end-3 . Inspect the result

>> cac{18}(1:end-3)
ans =
   22.9500
    3.4100
   22.0500
   23.9500
    4.4100
   25.0500
>> cac{7}(1:end-3)
ans =
   180
   180
   180
   181
   181
   181
cac{19}(1:end-3)
ans =
  6×1 cell array
    {'Limits	22	to	24	[dBm]	Passed'}
    {'Limit	6	[%]	Passed'            }
    {'Limit	30	[%]	Passed'            }
    {'Limits	22	to	24	[dBm]	Passed'}
    {'Limit	6	[%]	Passed'            }
    {'Limit	30	[%]	Passed'            }