Read data from a tricky text file

10 次查看（过去 30 天）
fsgeek
fsgeek 2015-9-27
评论： fsgeek 2015-9-28
Dear all,
I would like to read numeric data from a file which has the following standard format:
1 (15, 16, 266, 251)
2 (16, 17, 267, 266)
3 (17, 18, 268, 267)
4 (18, 19, 269, 268)
5 (19, 20, 270, 269)
6 (20, 21, 271, 270)
7 (21, 22, 272, 271)
8 (22, 23, 273, 272)
9 (23, 24, 274, 273)
The data is tab separated and number of rows arbitrary. I would like to end up with a variable containing the values of the left-most column, and the data in the parentheses should be treated as a single vector per row.
e.g.:
>> data{1}
{[1]}, {[15, 16, 266, 251]}
>> data{2}
{[2]}, {[16, 17, 267, 266]}
As long as I can access the the data as two numeric columns, I'd be happy!
I have tried importdata(), dlmread() and fget methods. They all seem to return each row of data as a cell of characters.
Thanks in advance for the help!
Best regards,
Louis

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

采纳的回答

per isakson
per isakson 2015-9-27
编辑：per isakson 2015-9-27
Assuming "data in the parentheses" all have equal length. Why cell array? Isn't this good enough?
fid = fopen( 'cssm.txt' );
cac = textscan( fid, '%f%f%f%f%f', 'Delimiter', {'\t',','} ...
, 'Whitespace',' ()', 'CollectOutput',true );
fclose( fid );
num = cac{:};
>> num
num =
1 15 16 266 251
2 16 17 267 266
3 17 18 268 267
4 18 19 269 268
5 19 20 270 269
6 20 21 271 270
7 21 22 272 271
8 22 23 273 272
9 23 24 274 273
>> num(2,2:end)
ans =
16 17 267 266
where cssm.txt contains the data of your question.
  1 个评论
fsgeek
fsgeek 2015-9-28
No need for cell arrays, that was just a demo. This method works great, thanks!

请先登录，再进行评论。

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Large Files and Big Data 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by