How can I skip data while reading values from text file?

[z1, HH, TT,z2,z3,z4,z5,z6,z7,z8,z9] = textread('A.txt', '%f %f %f %f %f %f %f %f %f %f %f ' );

I am reading values from text file with this code. But before reading values, I have to delete the other parts with my hand. And I only want to read data when data's format like

899.0 997 13.2 6.2 63 6.65 170 16 295.2 314.8 296.4 this.

How can I skip the other parts in the text file which are not proper to read values?

I mean I need something like this,

if this row is not proper for my reading format, skip this row and continue to read from next row.

Answer 1

[Simon Chan]

I try to use function fgetl as follows:

Noticed that the first 2 rows have data format different from others, so they are removed from the following code.

fid = fopen('A.txt', 'rt');
tline = fgetl(fid);
Counter = 1;
while ischar(tline)
    if ~isempty(str2num(tline))
        rawdata{Counter,1} = tline;                         % Store the required data
        Counter = Counter + 1;
    end
    tline = fgetl(fid);
end
fclose(fid);
value_in_cell = cellfun(@(x) str2num(x),rawdata,'uni',0);   % Convert from string to number
length_in_cell = cellfun(@length,value_in_cell);            % Calculate the number of data per row
idx = length_in_cell==11;                                   % Index for row having 11 data
value = cell2mat(value_in_cell(idx));                       % Convert from cell to matrix

[Muhammed Ali Fettahoglu]

Thank you for your answer

[Muhammed Ali Fettahoglu]

idx = length_in_cell==(11); % Index for row having 11 data

How can I add 7 and 9 data too? I need rows with 7,9 and 11 data.

For example;

1000.0 250 (2 data)

914.0 997 6.8 -3.2 49 3.32 287.2 297.0 287.8 (9 data)

850.0 1580 2.8 -15.2 25 1.39 170 2 289.1 293.4 289.3 (11 data)

250.0 10540 -52.9 280 44 327.3 327.3 (7 data)

In this example I need last 3 rows, and I will just use the second and third column. I need them if both of them are exist.

[Simon Chan]

If the length of the data in a row are different, say 2,7,9 & 11 in your case, it is better to manipulate the numbers in a cell array (Variable value_in_cell in the above code).

Or you need to identify the locations of the missing data in each row and assign NaN into it.

The following modified code is going to put NaN for the first two rows after the existing numbers. Noticed that if the missing data is in the middle, then the following code doesn't work.

addlength = max(length_in_cell)-length_in_cell;                                             % Calculate the difference in number of data vs max number
cellfun(@(x) [x,NaN(1,y)],value_in_cell,num2cell(addlength))                                % Calculate how many NaN needs to add at the end of the data
samelength_in_cell = cellfun(@(x,y) [x,NaN(1,y)],value_in_cell,num2cell(addlength),'uni',0);% Add NaN to those data having less data
value = cell2mat(samelength_in_cell);                                                       % Convert to matrix