Separating text files according to latitude and longitude

1 次查看（过去 30 天）

显示更早的评论

Tanmoyee Bhattacharya 2023-4-20

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1950293-separating-text-files-according-to-latitude-and-longitude

编辑： Tanmoyee Bhattacharya 2023-5-4

I have various text files namely

SNOWBAND_27.775_92.325.txt

SNOWBAND_27.775_92.425.txt

SNOWBAND_27.825_89.225.txt

SNOWBAND_27.825_89.275.txt

SNOWBAND_27.825_92.275.txt

SNOWBAND_27.825_92.325.txt

SNOWBAND_27.825_92.375.txt

SNOWBAND_27.825_92.425.txt

SNOWBAND_27.825_92.475.txt

I have another latlon file which contain latitude and longitude of

27.825 92.275

27.825 92.325

27.825 92.375

I want to separate the text files with matching lat and lon of latlon file.

If there is any way to separate the files.

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

请先登录，再回答此问题。

回答（1 个）

dpb 2023-4-20

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1950293-separating-text-files-according-to-latitude-and-longitude#answer_1219778

在 MATLAB Online 中打开

Sure. Just read the lat/lon data file, substitute the dot woth underscore and do a dir() with that string in the filename wildcard expression to return the specific file.

latlon=readlines('yourlocationsfile.ext');
for i=1:numel(latlon)
  ll=strrep(latlon(i),'.','_');
  d=dir("SNOWBAND*"+ll+".txt");
  fn=fullfile(d.folder,d.name);
  % do whatever with the file here
  ...
end

First time I ran this I'd probably add the fully-qualified filename to the latlon file to go with it so had them both together; then just read the one file and get what you're looking for. Probably make sense to also separate out the lat/lon data into separate values for lat and long as numeric values to be able to do searches for ranges and/or specific values directly as well. Preprocessing and creating a more useful database could save a bunch of time later on...

9 个评论
显示 7更早的评论隐藏 7更早的评论

dpb 2023-5-3

在 MATLAB Online 中打开

Use the debugger to step through and see what isn't as you expect.

The conclusion has to be that the file isn't located where you think it is or there isn't one of the particular number that matches the one you're trying to find.

But, we can't see your file structrure from here although I'd strongly recommend against leaving the default names and with spaces in the folder names; it just makes for a mess to have to ensure code against.

What does

dir(fullfile(['C:\Users\DELL\Desktop\New folder (4)' '*.txt']))

return?

Tanmoyee Bhattacharya 2023-5-4

编辑：Tanmoyee Bhattacharya 2023-5-4

Sir,

Thankyou for your suggestion. It works for me. I had to do this for working directory of matlab. Before I didnot use strcat but my input was string array. The code is

clc;

clear all;

latlon=xlsread('C:\Users\hp\Desktop\new\Book1.xlsx');

fnames=sprintf('SNOWBAND_%.3f_%.3f.txt.txt',latlon(1,:));

% fnames1=sprintf('SNOWBAND_%.3f_%.3f.txt',latlon(2,:));

a=strcat(fnames);

fn=fullfile('C:\Users\hp\Documents\MATLAB',a);

movefile(fn,'C:\Users\hp\Documents\MATLAB\New Folder');

My query is I able to extract file for individual latlon. If I have to do for multiple lat lon how can I modify the code? Any suggestion.

请先登录，再进行评论。

请先登录，再回答此问题。