concatenate and replace comma by dot
3 次查看(过去 30 天)
显示 更早的评论
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 个评论
采纳的回答
Jan
2012-12-17
编辑:Jan
2012-12-18
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{:});
8 个评论
Jan
2012-12-20
@Momo: Have you seen the [EDITED] section in my answer? If not, do you have any reason to be inpatient?
更多回答(1 个)
另请参阅
类别
在 Help Center 和 File Exchange 中查找有关 Text Data Preparation 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!