Textscan - remove rows with special character

I'm trying to read in a dataset, though it contains some rows with missing values which needs to be removed. The missing values are represented by a '?' in the dataset.

example of 3 rows:

1056784,3,1,1,1,2,1,2,1,1,2
1057013,8,4,5,1,2,?,7,3,1,4
1059552,1,1,1,1,2,1,3,1,1,2

Right now i'm doing this:

fid = fopen('bcw.data');
adata = textscan(fid,'%f%f%f%f%f%f%f%f%f%f%f','delimiter',',');
fclose(fid);

I need to remove the middle row (along with any other that contain a '?'), can anyone help with this? Thanks

Answer 1

[Walter Roberson]

Did you try the TreatAsEmpty option? When used, the value that will be substituted is controlled by the EmptyValue option, default NaN.

adatacell = textscan(fid,'%f%f%f%f%f%f%f%f%f%f%f','delimiter',',', 'TreatAsEmpty', '?', 'CollectOutput', 1);
adata = adatacell{1};
adata(any(isnan(adata),2),:) = [];   %delete rows that have a NaN

[Mathias Fynbo]

Thanks, this did exactly what i wanted. I saw the TreatAsEmpty in the docu, but didn't fully understand it's usage. Thanks again.