Adding a string in front of every variable in a table

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.

 Akzeptierte Antwort

Voss
Voss am 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 Kommentare

BA
BA am 20 Sep. 2022
Thank you!
Or using the string data type...
t.Properties.VariableNames = "Table_" + t.Properties.VariableNames;

Melden Sie sich an, um zu kommentieren.

Weitere Antworten (0)

Kategorien

Mehr zu Characters and Strings finden Sie in Hilfe-Center und File Exchange

Produkte

Version

R2022a

Gefragt:

BA
am 20 Sep. 2022

Kommentiert:

am 21 Sep. 2022

Community Treasure Hunt

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

Start Hunting!

Translated by