How to delete column and char from text file

Hello

I have a .txt file that contain string of characters, and then 3 column: time,number and letters.

I want to delete the first 3 rows and column 1 and 2.

879_GRE_ABC    Fecha grabaciףn : 08/03/2004  Nתmero ID  : 879_GRE_ABC  N° GRABADORA : SH0212115 1.02h  N÷ tarjeta MMC :   Versiףn Synetec : Versiףn 2.00 Release 2 RR (ms) export from 10:15:57:000 to 10:15:55
10:15:57  1000  A      
10:15:58  1000  C      
10:15:59  1000  C      
10:16:00  860  C      
10:16:01  1000  C      
10:16:02  460     C      
10:16:03  1000  C      
10:16:04  900  C      
10:16:05  1100  C      
10:16:06  100  C

I the end I want to get only column of the number:

1000
1000
1000
860  
1000
460
1000
900
1100
100

Thanks,

Roi

Answer 1

[Azzi Abdelmalek]

fid = fopen('file.txt');
a = textscan(fid, '%s  %f  %s','headerlines',3);
fclose(fid);
data=a{2}

[Azzi Abdelmalek]

Roi commented

Thanks

[Jan]

Please accept this answer, if it solves your problems.

[Roi]

How should I combine it in my algorithem If I read files from directory as below?

f = dir ('*.txt);
for t=1:length(f); 
g= ( f(t).name); 
Vec=load(g); 
disp(f(t).name )
C1 = find ( Vec>200 & Vec < 2000 ); ........

[Azzi Abdelmalek]

Your question is not clear

[Roi]

I want to read those files from folder automatic ( I have 700 files on folder that I need to analyze).

right now I loads the all files as below and analyze them automatic:

f = dir ('*.txt); for t=1:length(f); g= ( f(t).name); Vec=load(g); disp(f(t).name ) C1 = find ( Vec>200 & Vec < 2000 ); ........

In this case I can't read the files because the contain string of characters.

I want to read the files automatic and delete the first 3 rows that contain string of characters and delete column 1 and 3 too.

Answer 2

[Roi]

hello

When I use below command I got a NAN between the numbers and got about 338 lines.

fid = fopen('file.txt'); a = textscan(fid, '%s %f %s','headerlines',3); fclose(fid); data=a{2}

Why it's happened?