MATLAB: Concatenate and replace comma by dot

comma to dotconcatdecimal commadecimal pointdecimal radixradix pointsprintf

Hello, I have a series of 300 files with names respectively from data-1.dat to data300.dat. Each file consist of 6 columns and 25 rows (files contain scalars with comma instead of dot, ex: 3,21223232 and a header line) I want to concatenate all files into one matrix and I'm using the code below:
    % code
  numfiles = 300; 
  concat= cell(1, numfiles); 
  for i=1:300; 
  i
  filename = sprintf(data-%d.dat, i); 
  concat{i} = importdata(filename, '\t'); 
  end 
  the_struct = [concat{:}]; 
  M = [the_struct.data];
For data that doesn't have a comma the code work very well, otherwise it doesn't. Anyhelpful answer is very welcome. Thank you in advance.

Best Answer

numfiles = 300; 
concat   = cell(1, numfiles); 
for ii = 1:numfiles 
  filename  = sprintf('data-%d.dat', ii); 
  concat{ii} = strrep(fileread(filename), ',', '.'); 
end
newFile = fullfile(tempdir, 'JoinedFile.dat');
FID = fopen(newFile, 'w');
if FID == -1, error('Cannot open file for writing'); end
fprintf(FID, '%s', concat{:});
fclose(FID);
Now the new file contains all data with dots instead of commas and can be imported at once.
[EDITED] Remove headerlines, which start with 'F':
concatC = cell(1, numfiles); 
for ii = 1:numfiles 
  filename   = sprintf('data-%d.dat', ii); 
  Str        = strrep(fileread(filename), ',', '.');
  CStr       = regexp(Str, '\n', 'split');
  CStr(strncmp(CStr, 'F', 1)) = [];
  % Perhaps:
  if isempty(CStr{end})
    CStr(end) = [];
  end
  concatC{ii} = CStr(:);
end
concat = cat(1, concatC{:});
Related Question