MATLAB: TEXTSCAN not value, comma, space problem.

fixed widthtextscan

Hi,

when a file contains both a space and a comma separated and none value data as appendix,

solutionestimate = textscan(fid,'%s %s %f %s %s %s %s %s %s %f %f %f %f %f %f %f ' ...
                           , 'Delimiter', {' ',','} , 'MultipleDelimsAsOne',  true,);

output does not work correctly. Columns are shifting due to non-values.How can I solve this?

Best Answer

Use readtable instead with a FixedWidthImportOptions object. You can begin by seeing if detectImportOptions can figure it out on its own; if not, edit the returned object to match the specific file format.

Related Solutions

MATLAB: I want to read this text file from Matlab directly and want to import data of all columns into work space in an array.

Your file appears to contain 10 lines. You ask to skip the first 4, which would leave 6. You then ask to read 7 lines. You are going to have difficulty with the 7th value.

MATLAB: Import data with column separated with a comma, and comma as decimal place symbol

I developed the following code, reading and modifying the comma and other symbol in the text.

fid = fopen([PathAndFileName,'.csv'],'r');                 % Open file
C = textscan(fid, '%s');                                   % Read file
fclose(fid);                                               % Close file
C=strrep(C{1,1},'","',' ');                                % Modify "," into a space
C=strrep(C,'"','');                                        % Delete remaining "
C=strrep(C,',','.');                                       % From comma to point decimal simbol
Data=zeros(numel(C),length(str2num(C{end,1})));            % Initialize matrix
for n = 1:numel(C)
   Data(n,:) = str2num(C{n,1});                            % Divide all rows into the columns
end

Best Answer

Related Solutions

MATLAB: I want to read this text file from Matlab directly and want to import data of all columns into work space in an array.

MATLAB: Import data with column separated with a comma, and comma as decimal place symbol

Related Question