Read specific column from txt file

2012 7 20
1 个回答
回答已采纳
6 次查看（30 天）

0 个投票

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

1 个投票

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更早的评论 隐藏 1更早的评论

Aleksandra
Aleksandra 2012-7-22
Thanks! But I don't know why it doesn't work.
It says n =
[0x1 double]
ans =
Empty matrix: 0-by-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 个）

类别

在 帮助中心 和 File Exchange 中查找有关 Matrices and Arrays 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by