How can I extract quickly the numbers separated my commas and parenthesis from a txt file?

5 次查看（过去 30 天）
Sim
Sim 2021-8-9
评论： Wan Ji 2021-8-9
How can I extract quickly the numbers separated by commas and parenthesis from a txt file?
My data in the txt file are like these ones (please see attached the test.txt file):
(247, 4879) 507375.4469844637
(248, 6707) 434984.2860625947
(248, 7948) 454158.15272926027
(248, 8361) 17942.0
(249, 811) 161190.0
(250, 595) 148941.7522329302
(250, 6267) 141033.34299772125
As output, I would like a matrix with 3 columns like this:
247 4879 507375.4469844637
248 6707 434984.2860625947
248 7948 454158.15272926027
248 8361 17942.0
249 811 161190.0
250 595 148941.7522329302
250 6267 141033.34299772125
  2 个评论
the cyclist
the cyclist 2021-8-9
It would be easier for us to help if you uploaded your text file, or a smaller representative text file.
Then we don't have to guess at the exact format of your file, and we can easily test a potential solution.

请先登录，再进行评论。

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

采纳的回答

Dave B
Dave B 2021-8-9
It's not the most elegant solution, but as you said 'quickly' :)
a=readmatrix('test.txt',"Whitespace",'(','Delimiter',{')' ','})
This says treat the open parentheses as whitespace, and the close parentheses as a delimiter (because you don't have one between the second and third columns.
Could also have done:
a=readmatrix('test.txt','Delimiter',{'(' ')' ','},'LeadingDelimitersRule','ignore')

更多回答（1 个）

Wan Ji
Wan Ji 2021-8-9
It is quite easy to do so.
fid = fopen('a.txt','rt'); % a.txt is your file name
a = textscan(fid,'(%f, %f) %f');
a = cell2mat(a)
Then variable a is

类别

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

标签

Community Treasure Hunt

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

Start Hunting!

Translated by