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