Adding a string in front of every variable in a table
3 vues (au cours des 30 derniers jours)
Afficher commentaires plus anciens
I was looking to make a script that added a string in front of every variable in my table.
For example, I want to add "Table_" in front of every variable in the table I've attached to this post.
0 commentaires
Réponse acceptée
Voss
le 20 Sep 2022
% read the table
t = readtable('Ztable.xlsx','VariableNamingRule','preserve');
% modify the variable names
t.Properties.VariableNames = strcat('Table_',t.Properties.VariableNames);
% save the table
writetable(t,'Ztable_modified.xlsx')
2 commentaires
Eric Sofen
le 21 Sep 2022
t.Properties.VariableNames = "Table_" + t.Properties.VariableNames;
Plus de réponses (0)
Voir également
Catégories
En savoir plus sur Logical dans Help Center et File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!