MATLAB Answers

Get "@" back in a table header (R2017b) when saving

48 ビュー (過去 30 日間)
JM
JM 2021 年 2 月 23 日
回答済み: JM 2021 年 2 月 26 日
I have got a tabulated data-set which contains "@" in its coloum header (e.g name@domain). When loading this table in Matlab (R2017b) this header gets replaced by name_domain.
I need to do some post-processing on the data and the need the correct header back (i.e. with "@") in the final post processed data when saved as ascii file.
How to achive this in Matlab R2017b?

回答 (2 件)

Matt J
Matt J 2021 年 2 月 23 日
編集済み: Matt J 2021 年 2 月 23 日
For example,
T=table(1,'VariableNames',"name_domain")
T = table
name_domain ___________ 1
T.Properties.VariableNames = replace(T.Properties.VariableNames,'_','@')
T = table
name@domain ___________ 1
  12 件のコメント
Walter Roberson
Walter Roberson 2021 年 2 月 25 日
To be honest, the easiest way would be to upgrade MATLAB releases.
Second easiest way, if you are using MS Windows, would be to generate two seperate files, and then use
system(sprintf('copy "%s"+"%s" "%s"', first_tempfile, second_tempfile, desired_file))
The third easiest way would be to fopen() the file and fprintf() a line at a time, using appropriate formatting.

サインインしてコメントする。


JM
JM 2021 年 2 月 26 日
Thanks for all the answers. Upgrading seems the best way out of this but that is not going to happen any time soon.

タグ

製品


リリース

R2017b

Community Treasure Hunt

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

Start Hunting!

Translated by