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

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

[the cyclist]

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.

[Sim]

@the cyclist thanks for the comment...I have just attached the txt file (i.e. test.txt)

Answer 1

[Dave B]

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')

[Sim]

Perfect! Many thanks @Dave B :) .... (sorry I should be more specific with 'quickly'... I meant a fast way to extract the data...)

Answer 2

[Wan Ji]

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

[Sim]

Many thanks @Wan Ji !! It is even faster!

I would accept both answers!

[Wan Ji]

Happy to help you