remove table header row
385 ビュー (過去 30 日間)
I have the attached table which I wish to
1) Remove the header row.
2) duplicate the second column and append to end, making a third column
3) convert resulting n x 3 structure to a text file.
I have tried converting the table to an array, and then duplicating the second column and appending it to the end making a gthord coliumn, without much luck
Any help greatly appreciated
dpb 2019 年 5 月 1 日
編集済み: dpb 2019 年 5 月 1 日
Should show your work when you've tried something that seems like should but doesn't...it's really quite a straightforward task--tables really do simplify a lot of machinations, particularly when have differing data types as here, for example, between datetime and double.
tst=AUDCAD1d(1:10,:); % again, only a little is as good as a whole lot...
tst.New=tst.Open; % make a new column with content of second
writetable(tst,'AUD.csv','WriteVariableNames',0) % write a csv file without header...
See what we gots...
>> type AUD.csv
looks to satisfy requirements to me... :)
Excepting looks like there's an extra space on the time data...hmmm, let's see---
and indeed, there is. Might want to clean that up altho it may not hurt depending on the use of the file.
その他の回答 (0 件)
Find more on Numeric Types in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!Start Hunting!