Choose specific rows from txt files

1 次查看（过去 30 天）
Pap
Pap 2011-4-19
Hello,
I work on the below sample of a txt file:
STOCK DATE TIME PRICE VOLUME
ETE 04/01/2010 10145959 18.31 500 Big Cap
ALPPHA 04/01/2010 10150000 18.01 70 Big Cap
ETE 04/01/2010 10170000 18.54 430 Big Cap
ABC 04/01/2010 10190000 18.34 200 Big Cap
%How can I choose to keep specific columns by STOCK (column 1). To keep only rows for ETE for instance?
% And how can I keep only rows for specific values of lets say column 3 TIME ( say exclude values from 10140000-10161000, or keep 10170000-10180000) , and extract them to a new txt file?
Many thanks in advance,
Panos

请先登录，再回答此问题。

回答（1 个）

Chirag Gupta
Chirag Gupta 2011-4-19
You should be able to do most of it using textscan smartly.
http://www.mathworks.com/access/helpdesk/help/techdoc/ref/textscan.html
Use textscan to read/extract data out and then output it in your desired format using fprintf.

类别

在 Help Center 和 File Exchange 中查找有关 String Parsing 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by