remove table header row
411 ビュー (過去 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.