Problem only reading in select data

3 次查看（过去 30 天）
Zach
Zach 2011-4-6
Hello all,
I am currently in the process of working on reading in this data file into MATLAB however I am having issues grabbing only the data I want. The file is formatted as follows:
*Sale Item Price Profit
1200 00213 12.21 3.26*
Date Salesperson Cost Sold At Net Money
1/10/11 12 13.45 16.45 3
1/14/11 14 3.98 3.48 -0.5
1/24/11 03 4.60 14.60 10
*Sale Item Price Profit
65 01452 13.78 6.12*
Date Salesperson Cost Sold At Net Money
1/04/11 11 20.10 40.10 20
1/06/11 11 20.11 16.11 4
*Sale Item Price Profit*
...
And so on.
I only want to have Matlab read in the data within the asterisks. Any thoughts on how to do this?
Thanks
  4 个评论
显示 2更早的评论
Matt Tearle
Matt Tearle 2011-4-6
(To clarify the clarification: or are you looking to read data in any block with a certain headerline? ie "Sale Item Price Profit")
Zach
Zach 2011-4-6
I think my answer to this question if I'm following you correctly is I wish to read only the data associated with the Sale, Item, Price, Profit.

请先登录，再进行评论。

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

采纳的回答

Matt Tearle
Matt Tearle 2011-4-6
On the off-chance Walter's approach doesn't work (eg there are more than two block formats in the file), here's a more brute-force approach:
fid = fopen('asterisk.txt','rt');
data = [];
while ~feof(fid)
thisline = fgetl(fid);
if strncmpi('sale',thisline,4)
thisdata = textscan(fid,'%f %f %f %f','collectoutput',true);
data = [data;thisdata{1}];
end
end
fclose(fid);
You can modify the if statement to match whatever specific pattern you want.
  8 个评论
显示 6更早的评论
Zach
Zach 2011-4-6
Thank you all for your help and if it isn't too much trouble I have one final understanding question. What exactly does the thisline portion do along with what does the 4 represent in the strncmpi function?
Matt Tearle
Matt Tearle 2011-4-6
Walter, that makes sense. Thanks for the non-textscan version.
Zach, fgetl reads a single line of text. Then sctrncmpi is comparing the the first 4 characters of that string with the string 'sale' (that's what the 4 does). You can adapt this if, for example, you had other blocks that also started with "sale" (but then had something else after).

请先登录，再进行评论。

更多回答（1 个）

Walter Roberson
Walter Roberson 2011-4-6
textread() with 'CommentStyle', {'Date', 'Profit'}
  5 个评论
显示 3更早的评论
Walter Roberson
Walter Roberson 2011-4-6
Zach: Which version of MATLAB are you using? Using a cell array of a pair of strings has been supported since at least 2007b, but there was probably a time when it wasn't supported.
Matt: You snooze, you loze! ;-)
Zach
Zach 2011-4-6
Sorry I went out to lunch I am using Matlab 6.5 so it probably wasn't supported in this version I will try to use Matt's code listed below.

请先登录，再进行评论。

类别

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

标签

产品

Community Treasure Hunt

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

Start Hunting!

Translated by