Why do I have an Error using readtable?
29 views (last 30 days)
Does anyone know why I get the following error when running my code (shown below):
Reading failed at line 26. All lines of a text file must have the same
number of delimiters. Line 26 has 0 delimiters, while preceding lines
Note: readtable detected the following parameters:
'Delimiter', '\t ', 'MultipleDelimsAsOne', true, 'ReadVariableNames',
false, 'Format', '%q%f%f%f%f'
Error in EXP2_Ver11_Evaluation_of_Meteonorm_simulation (line 68)
T = readtable(File_from_Meteo2, 'Headerlines', 12); %table
starts at line 12
The error mentions "Line 26" but I only ask it to read upto line 12 maximum.
I have also attached one of the files I am reading.
tempFileName2 = sprintf('t%d_o%d_zero-mon.txt',t,o);%get the zero file
File_from_Meteo2 = append(pathResults, tempFileName2); %Combine path and file name then assign it to the variable 'File_from_Meteo' to access the file
T = readtable(File_from_Meteo2, 'Headerlines', 12); %table starts at line 12
%If the txt file is for t=1, (i.e. tilt of 0) it represents a situation with no tilt, therefore read colum "H_Ghhor"
zero_subset = T(m:m, 'H_Gh');
%Otherewise the txt file represents a situation with a tilt, therefore read colum "H_Gkhor"
zero_subset = T(m:m,'H_Gk');
Dave B on 16 Aug 2021
Edited: Dave B on 16 Aug 2021
I don't see where you sepcified the last row you wanted to read, you specified to ignore the first 12. Range is good for this kind of thing:
As a bonus, you can also read the variable names directly:
t=readtable('t1_o1_zero-mon.txt', 'Delimiter', '\t', 'Range', '11:24', 'ReadVariableNames', true)