concatenate and replace comma by dot

Question

Momo 2012-12-17

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/56828-concatenate-and-replace-comma-by-dot

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.

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

请先登录，再回答此问题。

Answer 1

Jan 2012-12-17

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/56828-concatenate-and-replace-comma-by-dot#answer_68773

编辑：Jan 2012-12-18

在 MATLAB Online 中打开

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{:});