How to remove warning message when we read csv file?

19 views (last 30 days)
When I try to read csv file warning message coming. I want to eliminate that message. Since I have more than 30 csv files 30 times warning messages popping. How can I remove all warning message. Here is my code
clc
clear all
d=dir('i*.csv');
opts = detectImportOptions(d(1).name,"Delimiter",",");
T = {};
for i=1:numel(d)
fid = fopen(d(i).name,'r');
nhdr = 8 + cell2mat(textscan(fid,'Total Channels:%f',1,'HeaderLines',5,'Delimiter',','));
fid = fclose(fid);
if nhdr == 8 % skip no data in file cases if that occurs (dpb conjecture)
warning(['No data. Skipped file: ' d(i).name])
continue
end
opts.DataLines = [nhdr+2 inf];
opts.VariableNamesLine = nhdr+1;
T{i} = readtable(d(i).name,opts);
end
And warning message
Warning: Column headers from the file were modified to make them valid MATLAB identifiers before creating variable names for the table. The original column headers are saved in the VariableDescriptions property.
Set 'VariableNamingRule' to 'preserve' to use the original column headers as table variable names.

Accepted Answer

Mathieu NOE
Mathieu NOE on 1 Oct 2021
hello
simply add this line at the start of your code :
warning off
  1 Comment
Steven Lord
Steven Lord on 1 Oct 2021
That's a very large hammer that could mask real problems in the code.
If you're okay with getting the original column headers I'd follow the instructions in the warning and modify the readtable call.
Set 'VariableNamingRule' to 'preserve' to use the original column headers as table variable names.

Sign in to comment.

More Answers (0)

Products


Release

R2021a

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!