How to get last numerical value from column A only?
37 views (last 30 days)
Show older comments
isamh on 13 Mar 2020
Answered: Steven Lord on 13 Mar 2020
I have a CSV, I want to get the first and last value from column A.
I found the first value, which is: First = P(1);
i cant seem to get the last value, I tried: Last = P(end);
I get the last value from Column E instead of A
P(1,end) would be it.
More Answers (1)
Steven Lord on 13 Mar 2020
When you index into an array with just one index, you're using a technique called linear indexing. This basically treats your array like it was one long vector, as described in the "Indexing with a Single Index" section on this documentation page. You want to perform subscripted indexing, as Fangjun Jiang suggested and as the "Indexing with Element Positions" section on that documentation page states. That section mentions the end keyword will will be very useful in keeping your code generalized. This avoids hard-coding in the size of a particular array, letting your code automatically handle different sized inputs without needing modification.
Find more on Matrix Indexing 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!