extraction from notepad

1 次查看（过去 30 天）
Mate 2u
Mate 2u 2012-4-15
Hi everyone, I have data in a notepad in the format of:
SLV|41|T|10|05:29:49:887|01/08/2011|f2=38.8504
GLD|41|R|10|05:29:51:674|01/08/2011|f98=158.6
GLD|41|T|10|05:29:51:674|01/08/2011|f2=158.3659
SLV|41|R|10|05:30:05:254|01/08/2011|f98=39.1628
SLV|41|T|10|05:30:05:254|01/08/2011|f2=38.8504
GLD|41|R|10|05:30:06:994|01/08/2011|f98=158.6
I want to extract 4 things from the notepad and bring it in to matlab:
GLD f2 values, GLD f98 values
SLV f2 values and SLV f98 values.
Look forward to a reply soon.
Thank you
  1 个评论
Oleg Komarov
Oleg Komarov 2012-4-15
Are the vertical bars really there?
Since this question is related to your next one I'll tell you that you canimport SLV, GLD and just the numbers after f2 = ... dorectly. This will save you time.

请先登录，再进行评论。

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

回答（2 个）

bobby
bobby 2012-4-15
Well import in matlab in shape of an array and then remove all the other columns except the F-values. Or first open the notepad file in excel, so that it is converted in row/column format, and then import xls file in Matlab using xlsread('file.xls')
  3 个评论
显示 1更早的评论
bobby
bobby 2012-4-15
http://www.mathworks.com/help/techdoc/ref/importdata.html
I think this function can help you.
Mate 2u
Mate 2u 2012-4-15
Thanks but very vague

请先登录，再进行评论。

Oleg Komarov
Oleg Komarov 2012-4-15
Soluion with textscan:
fid = fopen('C:\Users\Oleg\Desktop\test.txt');
out = textscan(fid,'%3s%*[^=]%f','Delimiter','=');
fid = fclose(fid);

类别

在 Help Center 和 File Exchange 中查找有关 Data Import and Export 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by