How to handle multiple text files (geographical info) and finding a particular location from each text file?

3 views (last 30 days)
Hello matlab community,
I have multiple text files. Which contains time,value,lat,lon information. Each text file has a different dimension.
What I want is to extract all the information ( i.e. time,value) in a sorted manner for a particular (lon,lat) location occuring at all the text files which are of different dimension.
For example: I want to find all the values in sorted time format for a lon=100, lat=35, from all the text files.
I can share few text file if requires.
Thanking you in advance.

Accepted Answer

Image Analyst
Image Analyst on 6 Sep 2021
2 hours with no answer. Yeah, I guess you need to attach the text files before anyone tries to deal with this problem. We don't know what arrays you have, like arrays for lat, long, time, value, etc. So all I can suggest at this point is to use the sort() function. In the meantime try something like
latLon = [lat(:), longitude(:)]; % Get all lats and lons in an N-by-2 array.
% There may be repeats, so extract only the unique locations.
uniqueLocations = unique(latLon, 'rows');
for row = 1 : size(uniqueLocations, 1)
thisLat = uniqueLocations(row, 1);
thisLon = uniqueLocations(row, 2);
% Find rows with that location
theseRows = lat == thisLat & longitude == thisLon;
% Extract times and values
theseTimes = time(theseRows);
theseValues = values(theseRows);
% Now do something with them.
Image Analyst
Image Analyst on 7 Sep 2021
OK, but did you actually try to adapt my code? If so, did it work? Before I try I'd like to know. Also include your code.

Sign in to comment.

More Answers (0)

Community Treasure Hunt

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

Start Hunting!

Translated by