Why do I have an Error using readtable?
27 views (last 30 days)
Show older comments
Hannah on 16 Aug 2021
Commented: Hannah on 17 Aug 2021
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)
More Answers (0)
Find more on Tables in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!Start Hunting!