how to import numbers from a file
11 views (last 30 days)
Show older comments
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 Comments
Geoff Hayes
on 27 Feb 2020
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?
Answers (1)
Divya Gaddipati
on 2 Mar 2020
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!
0 Comments
See Also
Categories
Find more on Text Data Preparation in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!