extraction of numeric data with presence of text data

1 次查看(过去 30 天)
I want to extract x,y co-ordinate and amplitude data from the txt file but i am not getting any idea how to do so.
for eg.:- * Gp# 1[8,4] x,y = -14.46, 0 dT[7] Src Amplitude = 36.0
then i want output as
x y amplitude
1. -14.46 0 36.0
2.
3. and so on

采纳的回答

dpb
dpb 2021-4-2
编辑:dpb 2021-4-3
fid=fopen('abc.txt','r');
abc=textscan(fid,'%s',inf,'Delimiter','\n','HeaderLines',2,'commentstyle','1','texttype','string');
fid=fclose(fid);
abc=string(abc{:});
abc=abc(contains(abc,'Gp#'));
xy=str2double(split(extractBetween(abc,'x,y = ',' dT'),','));
ampl=str2double(extractAfter(abc,'Amplitude = '));
tABC=table(xy(:,1),xy(:,2),ampl,'VariableNames',{'x','y','amplitude'});
results in
>> head(tABC)
ans =
8×3 table
x y amplitude
______ ____ _________
-14.46 0.00 36.00
-14.46 0.00 35.00
13.39 0.00 34.00
-18.75 0.00 32.00
19.82 0.00 36.00
-20.89 0.00 32.00
19.82 0.00 50.00
-5.89 0.00 36.00
>>
  6 个评论
Abhijit Sardar
Abhijit Sardar 2021-4-5
I will try don't know if i can do it since i am very new to matlab but really thanks for the help till this point.
dpb
dpb 2021-4-5
Well, give it a go and post your code and specific Q? if you get stuck...

请先登录,再进行评论。

更多回答(0 个)

Community Treasure Hunt

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

Start Hunting!

Translated by