Read specific column from txt file

1 次查看（过去 30 天）
Aleksandra
Aleksandra 2012-7-20
Hi, I would like to read specific column from txt file (values - 3230,3190,3220 and so on). So how can I do it?
Thanks.
Here is the txt file looks like:
1 7/19/2012 11:46:38 AM L 0 254 3230 3.6 0.18 97
1 7/19/2012 11:46:52 AM L 0 249 3190 3.6 0.18 97
1 7/19/2012 11:47:05 AM L 0 252 3220 3.6 0.18 97
2 7/19/2012 11:49:05 AM L 0 390 4180 4.2 0.18 95
2 7/19/2012 11:53:09 AM L 0 399 4240 4.5 0.18 91

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

采纳的回答

bym
bym 2012-7-21
fid = fopen('test.txt')
n = textscan(fid,'%*d %*s %*s %*s %*s %*f %*f %f %*f %*f %*f','delimiter',' ')
n{:}
ans =
3230
3190
3220
4180
4240
  3 个评论
显示 1更早的评论
Walter Roberson
Walter Roberson 2012-7-22
编辑：Walter Roberson 2012-7-22
It would be safer to remove the embedded blanks in the format string. Also, since all those fields are being thrown away, it does not make sense to do the extra processing of deciding whether they are proper numeric form. Suggested format:
[repmat('%*s',1,6), '%f', repmat('%*s',1,3)]
Also, is your delimiter blanks or tabs? It looks like blanks, but I cannot be sure. If it is blanks, you can also drop the explicit 'delimiter' parameter/value pair.
Aleksandra
Aleksandra 2012-7-23
Yeah, I didn't use 'delimiter' since thre is no delimiter there. Thanks a lot!!

请先登录，再进行评论。

更多回答（0 个）

类别

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

标签

Community Treasure Hunt

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

Start Hunting!

Translated by