Read csv files by regulare expression function

Question

Damith 2015-5-7

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/215461-read-csv-files-by-regulare-expression-function

评论： Damith 2015-5-8

采纳的回答： Walter Roberson

在 MATLAB Online 中打开

Hi,

I have multiple .csv files in the following format from:

TRMM_1998_01_newntcl.csv
TRMM_1998_02_newntcl.csv
.
.
.
TRMM_1998_12_newntcl.csv
TRMM_1999_01_newntcl.csv
.
.
.
TRMM_1999_12_newntcl.csv

I have the following code and I need to modify to read by month (1-12). I appreciate if someone can help me to figure this out and modify the following code.

Thanks in advance.

      sad = dir('TRMM_*_newntcl.csv');
      cac = regexp( {sad.name}, '1998_[01]\d_[0-3]\_' ); 
      ism = not( cellfun( @isempty, cac ) );
      d   = sad(ism);
      ymdh=cell2mat(textscan([d.name], ...
              'TRMM_%4d_%2d_%2d%2d_newntcl.csv', ...
              'collectoutput',true));

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

请先登录，再进行评论。

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

Answer 1

Walter Roberson 2015-5-7

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/215461-read-csv-files-by-regulare-expression-function#answer_178174

在 MATLAB Online 中打开

month_to_match = 8;  %for example
str_for_month = sprintf('%02d', month_to_match);
regexp_for_month = [ '^TRMM_[12]\d{3}_[01]\d_' str_for_month '_'];
cac = regexp( {sad.name}, regexp_for_month );

3 个评论
显示 1更早的评论隐藏 1更早的评论

Walter Roberson 2015-5-8

在 MATLAB Online 中打开

regexp_for_month = [ '^TRMM_[12]\d{3}_' str_for_month '_'];

Damith 2015-5-8

OK. Thanks. This worked.

请先登录，再进行评论。

Answer 2

Stephen23 2015-5-7

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/215461-read-csv-files-by-regulare-expression-function#answer_178246

编辑：Stephen23 2015-5-7

在 MATLAB Online 中打开

You could avoid the whole regexp thing entirely by using my FEX submission datenum8601:

>> N = cellfun(@datenum8601, strrep({sad.name},'_','-'));
>> datevec(N)
ans =
      1998           1           1           0           0           0
      1998           2           1           0           0           0
      1998          12           1           0           0           0
      1999           1           1           0           0           0
      1999          12           1           0           0           0