How do you get rid of the VariableNamingRule warning when you do want it set to modify ?

200 ビュー (過去 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 ?

採用された回答

dpb
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
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 ExchangeEnvironment and Settings についてさらに検索

Community Treasure Hunt

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

Start Hunting!

Translated by