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
20190501095950 ,0.94472,0.94472
20190501095955 ,0.94473,0.94473
20190501100000 ,0.9447,0.9447
20190501100005 ,0.94471,0.94471
20190501100010 ,0.94473,0.94473
20190501100015 ,0.94471,0.94471
20190501100020 ,0.9447,0.9447
20190501100025 ,0.94475,0.94475
20190501100030 ,0.94474,0.94474
20190501100035 ,0.94476,0.94476
>>
looks to satisfy requirements to me... :)
Excepting looks like there's an extra space on the time data...hmmm, let's see---
>> tst.Var1.Format
ans =
'yyyyMMddHHmmss '
>>
and indeed, there is. Might want to clean that up altho it may not hurt depending on the use of the file.
