Read data from a tricky text file

Question

fsgeek 2015-9-27

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/245422-read-data-from-a-tricky-text-file

评论： fsgeek 2015-9-28

采纳的回答： per isakson

在 MATLAB Online 中打开

Dear all,

I would like to read numeric data from a file which has the following standard format:

(15, 16, 266, 251)
(16, 17, 267, 266)
(17, 18, 268, 267)
(18, 19, 269, 268)
(19, 20, 270, 269)
(20, 21, 271, 270)
(21, 22, 272, 271)
(22, 23, 273, 272)
(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

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

Answer 1

per isakson 2015-9-27

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/245422-read-data-from-a-tricky-text-file#answer_193877

编辑：per isakson 2015-9-27

在 MATLAB Online 中打开

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