writetable with spaces on header

I have a table: T
LastName Age Smoker Height Weight BloodPressure
_________ ___ ______ ______ ______ _____________
'Sanchez' 38 true 71 176 124 93
'Johnson' 43 false 69 163 109 77
'Diaz' 40 false 67 133 117 75
What I would like to do is output this table to a text file but with spaces in between LastName and BloodPressure like:
Last Name Age Smoker Height Weight Blood Pressure
_________ ___ ______ ______ ______ _____________
'Sanchez' 38 true 71 176 124 93
'Johnson' 43 false 69 163 109 77
'Diaz' 40 false 67 133 117 75

 Accepted Answer

header = {'Last Name', 'Age', 'Smoker', 'Height', 'Weight', 'Blood Pressure'};
Tcell = [header; table2cell(T)];
writecell(Tcell, 'YourFileName.txt', 'Delimiter', '\t')

6 Comments

Oh, yeat, forgot they'd introduced that, Walter...I need to find the time to update/reinstall...but not yet today! :(
Hi Walter,
Thanks. I'm getting the following error:
Undefined function or variable 'writecell'.
I'm trying to do this:
writecell(Tcell,[folder filename], 'Delimiter', '\t')
Where folder is just the path to the folder containing the file and filename is the name of the file
'C:\myfiles\001\YourFileName.txt'
writecell was not introduced until R2019a so you'll have to have lastest version to use it.
It is difficult to make appropriate recommendations when we do not know the release being used.
Crystall ball out for repair again, Walter? :)
Installed R2019a and it worked. Thanks a lot.

Sign in to comment.

More Answers (1)

dpb
dpb on 13 Jun 2019
You will have to write the table content via fprintf then; the writetable function doesn't have the flexibility to specify alternate headings and column names must be valid Matlab variable names which don't include spaces.

Categories

Asked:

Eth
on 13 Jun 2019

Commented:

Eth
on 14 Jun 2019

Community Treasure Hunt

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

Start Hunting!