Help with Complex loop to look through data in table in Matlab

1 view (last 30 days)
Sorry for broad question but I am stuck and need starting help with my data. I am using Matlab 2013b.
I have set of data which has GPS and also some data reading. They are in one table and you can separate them by RecordType which 2 is GPs and 1 is Data.
I need to look through the data to find first 'TEST POST START ' then I need to get the line above it, which is the GPS sentence stamp for that I need to get the latitude and longitude of all the position and calculate the distance.
I already have done code for calculating distance from GPs readings.
This is tricky part; I need to look for 'COATING FAULT ' or 'OVERLINE TO R.E.' data I need to get the data from that line.
Every part of my data is separate by 'TEST POST END ' or another 'TEST POST START ' so I need to calculate the distance from the line above each 'TEST POST until every 'OVERLINE TO R.E ' then I also carry on calculating distance until 'TEST POST END ' or the next 'TEST POST START '.
So in image I have attached I have selected what type data I have and where I need to select the data and calculate the distance for each area. Then I need all the information in new table where I can display and draw graph with them. So for that I need the distance to carry on so the second and other section of my data distance doesn’t start from 0 but from the last part.

Answers (0)

Products

Community Treasure Hunt

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

Start Hunting!