how to import numbers from a file

10 次查看(过去 30 天)
Hi all
i gave this text document named inventory.txt and it contais this data
part# cost quantity
127 23.44 146
643 18.20 87
443 143.19 13
801 15.34 66
I want to multiply the cost for each part by the quanatity and then add all costs to get total costs.I want to do this by extracting the costs and quantities and multiplying them. I tried using fget1(s), feof but i cant get them to work. any idea on how the extract the cost numbers and quanatity numbers?
  2 个评论
Geoff Hayes
Geoff Hayes 2020-2-27
Tarek - try using importdata. Note how, if you use this function, you can ignore the header row. Out of curiosity, does your data look exactly like that with spaces between each row?

请先登录,再进行评论。

回答(1 个)

Divya Gaddipati
Divya Gaddipati 2020-3-2
You can use importdata for this purpose.
d = importdata('inventory.txt');
This outputs a struct with 3 fields - "data", "textdata" and "colheaders"
data contains the numerical data in a matrix
textdata contains the text in an array of cells
colheaders contains the column headers
cost = d.data(:, 2);
quantity = d.data(:,3);
total_cost = cost .* quantity;
Hope this helps!

类别

Help CenterFile Exchange 中查找有关 Text Data Preparation 的更多信息

Community Treasure Hunt

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

Start Hunting!

Translated by