Dimensions of arrays being concatenated are not consistent.

Question

Arnab Paul 2022-11-1

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1841178-dimensions-of-arrays-being-concatenated-are-not-consistent

评论： Mathieu NOE 2022-11-7

采纳的回答： Mathieu NOE

6bbb44bb68_archive22.txt

在 MATLAB Online 中打开

I want to run this code over multiple text file. I want them as a xlsx file but showing

Dimensions of arrays being concatenated are not consistent.
Error in cell2mat (line 75)
m{n} = cat(2,c{n,:});
Error in RRSfiles (line 24)
data1 = array2table( cell2mat( textscan(as_text, fmt)), 'VariableNames', variablenames);

It worked with different files earlier though.

This is my code

myFolder = 'mydrive';
filePattern = fullfile(myFolder, '*22.txt'); % Files with .txt extension. The files are numbered as 1.txt, 2.txt etc
theFiles = dir(filePattern);
for k = 1:length(theFiles)
    baseFileName = theFiles(k).name;
    fullFileName = fullfile(theFiles(k).folder, baseFileName);
    fprintf(1, 'Now reading %s\n', fullFileName);
    Lines = readlines(fullFileName);
%variable names are on the first line
    variablenames = regexp(Lines(1), ',', 'split');
    variablenames(1:31) = ["Rrs400","Rrs410","Rrs420","Rrs430","Rrs440","Rrs450","Rrs460","Rrs470","Rrs480","Rrs490","Rrs500","Rrs510",...
        "Rrs520","Rrs530","Rrs540","Rrs550","Rrs560","Rrs570","Rrs580","Rrs590","Rrs600","Rrs610","Rrs620","Rrs630","Rrs640","Rrs650","Rrs660",...
        "Rrs670","Rrs680","Rrs690","Rrs700"];
    
    Lines( cellfun(@isempty, regexp(Lines, '^\d')) ) = [];
    
    as_text = strjoin(Lines, newline);
    
    fmt = ''; %delimiter
    data1 = array2table( cell2mat( textscan(as_text, fmt)), 'VariableNames', variablenames);
    writetable(data1, [baseFileName, '.xlsx'], 'sheet',1,'Range','A1')
    

I have attached the sample txt file. Any help will be appreciated

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

请先登录，再进行评论。

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

Answer 1

Mathieu NOE 2022-11-3

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1841178-dimensions-of-arrays-being-concatenated-are-not-consistent#answer_1090528

在 MATLAB Online 中打开

hello

this is my suggestion

get the data simply by this command : data = str2num(Lines(2));

myFolder = 'mydrive';
filePattern = fullfile(myFolder, '*22.txt'); % Files with .txt extension. The files are numbered as 1.txt, 2.txt etc
theFiles = dir(filePattern);
for k = 1:length(theFiles)
    baseFileName = theFiles(k).name;
    fullFileName = fullfile(theFiles(k).folder, baseFileName);
    fprintf(1, 'Now reading %s\n', fullFileName);
    Lines = readlines(fullFileName);
%variable names are on the first line
    variablenames = regexp(Lines(1), ',', 'split');
    variablenames(1:31) = ["Rrs400","Rrs410","Rrs420","Rrs430","Rrs440","Rrs450","Rrs460","Rrs470","Rrs480","Rrs490","Rrs500","Rrs510",...
        "Rrs520","Rrs530","Rrs540","Rrs550","Rrs560","Rrs570","Rrs580","Rrs590","Rrs600","Rrs610","Rrs620","Rrs630","Rrs640","Rrs650","Rrs660",...
        "Rrs670","Rrs680","Rrs690","Rrs700"];
    
    Lines( cellfun(@isempty, regexp(Lines, '^\d')) ) = [];
    
    data = str2num(Lines(2));    % <= get data  
    data1 = array2table(data, 'VariableNames', variablenames);
    writetable(data1, [baseFileName(1:length(baseFileName)-4), '.xlsx'], 'sheet',1,'Range','A1')  % remove .txt extension of baseFileName before saving to xlsx file
end

4 个评论
显示 2更早的评论隐藏 2更早的评论

Mathieu NOE 2022-11-4

在 MATLAB Online 中打开

then you can do that :

data = str2num(char(Lines(2:end))); % get data (one or multiple lines)

full code :

% myFolder = 'mydrive';
myFolder = pwd;
filePattern = fullfile(myFolder, '*22.txt'); % Files with .txt extension. The files are numbered as 1.txt, 2.txt etc
theFiles = dir(filePattern);
for k = 1:length(theFiles)
    baseFileName = theFiles(k).name;
    fullFileName = fullfile(theFiles(k).folder, baseFileName);
    fprintf(1, 'Now reading %s\n', fullFileName);
    Lines = readlines(fullFileName);
%variable names are on the first line
    variablenames = regexp(Lines(1), ',', 'split');
    variablenames(1:31) = ["Rrs400","Rrs410","Rrs420","Rrs430","Rrs440","Rrs450","Rrs460","Rrs470","Rrs480","Rrs490","Rrs500","Rrs510",...
        "Rrs520","Rrs530","Rrs540","Rrs550","Rrs560","Rrs570","Rrs580","Rrs590","Rrs600","Rrs610","Rrs620","Rrs630","Rrs640","Rrs650","Rrs660",...
        "Rrs670","Rrs680","Rrs690","Rrs700"];
    
    Lines( cellfun(@isempty, regexp(Lines, '^\d')) ) = [];
    
    data = str2num(char(Lines(2:end)));    % get data (one or multiple lines)
    data1 = array2table(data, 'VariableNames', variablenames);
    writetable(data1, [baseFileName(1:length(baseFileName)-4), '.xlsx'], 'sheet',1,'Range','A1')  % remove .txt extension of baseFileName before saving to xlsx file
end