Select/ Short rows from ASCII files

Import your ASCII file first. If you could make the data like the format below, it's straightforward to use ismember() and sort() function to achieve what you want.

Data={'ETE' '04/10/2010 10170000' 18.54 430 'Big Cap';
'ABC' '04/01/2010 10190000' 18.34 200 'Big Cap';
'YYY' '04/01/2010 10200000' 18.34 100 'Big Cap';
'ABC' '04/02/2010 10190000' 18.54 300 'Big Cap';}
Ind=ismember(Data(:,1),'ABC')
Stock_ABC=Data(Ind,:)
[Trash,Ind]=sort(datenum(Data(:,2),'mm/dd/yyyy HHMMSSFFF'));
Stock_Sorted=Data(Ind,:)

2 个评论
显示无隐藏无

Pap 2011-9-14

The thing is that it is a very large ASCII file. (almost 9,000,000 rows) so I cant make the data as the format above

Thanks

Panos

Fangjun Jiang 2011-9-14

I don't mean to manually type into that format. You can use uiimport(),importdata(), xlsread() or textscan() to import your ASCII file and then make your data into a cell array.

请先登录，再进行评论。

Answer 2

Pap 2011-9-14

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/15860-select-short-rows-from-ascii-files#answer_21511

Thanks so much Fangjun!

Is there any way to export the result in a new ASCII file?

Panos

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

Fangjun Jiang 2011-9-14

Yes. xlswrite() can write a cell array to an Excel file which I think would be better for this type of information. You can also use csvwrite(), dlmwrite() to write to an ASCII text file.

请先登录，再进行评论。