How do you get rid of the VariableNamingRule warning when you do want it set to modify ?
133 次查看(过去 30 天)
显示 更早的评论
Hi, I have the following code:
opts = detectImportOptions(fullfile(file_B_path, file_B_name)); % Detects import of table
opts = setvartype(opts, 'ID', 'string'); % Sets ID to string datatype
opts = setvartype(opts, 'RvCCompliance', 'string'); % Sets RvC Compliance to string datatype
---> opts.VariableNamingRule = 'modify';
file_B = readtable(fullfile(file_B_path, file_B_name),opts); % Imports table
and I keep getting the following warning:
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.
I know that variablenamingrule is set to modify, in fact, I want it to be set to modify. Why wont adding the line with the pointer get rid of this messege ?
0 个评论
采纳的回答
dpb
2023-6-16
It's annoying to be constantly nagged, agreed. But, setting it explicitly doesn't affect whether it is generated or not as you've discovered.
But, while a pain to have to do every time use readtable, it's relatively simple to fix...
opts = detectImportOptions(fullfile(file_B_path, file_B_name)); % Detects import of table
opts = setvartype(opts, 'ID', 'string'); % Sets ID to string datatype
opts = setvartype(opts, 'RvCCompliance', 'string'); % Sets RvC Compliance to string datatype
w=warning('off','MATLAB:table:ModifiedAndSavedVarnames'); % turn off annoying warning, save state
file_B = readtable(fullfile(file_B_path, file_B_name),opts); % Imports table
warning(w); % reset warning level
Since 'modify' is the default state for the name preservation property, it doesn't need to be set in the options struct and makes no difference if it is (as you've seen).
3 个评论
Peter Perkins
2023-7-17
Santiago, this warning is a known issue that is left over from the days before VariableNamingRule. For now, the work-around is what dpb suggests.
更多回答(0 个)
另请参阅
类别
在 Help Center 和 File Exchange 中查找有关 Characters and Strings 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!