regexp and string rearrange in text file

Question

Rashmil Dahanayake 2014-7-16

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/142018-regexp-and-string-rearrange-in-text-file

评论： Rashmil Dahanayake 2014-7-16

I have a .txt file which has about 350 lines. The content is the .txt file is in following format

Open loop test -19-06-2014
Current Injection 2 -18-06-2014
Parameter sweep -17-06-2014
Controlled input -16-06-2014
Open loop test 2 -14-06-2014

I need to take the date to the beginning of each line and change the format to yyyy/mm/dd

ie in following format

2014/06/19 Open loop test 
2014/06/18 Current Injection 2

Following is the code I have so far

%open file
  fid =fopen('lsit2.txt');
  C=textscan(fid,'%s','delimiter','\n');
  % search for date string and updating the format
  for k=1:size(C{1,1},1)  % repeat for each line
  str=C{1,1}{1};
  date = regexp(str, '(\d+)-(\d+)-(\d+)', 'tokens');
  newdate_format= sprintf('%s/%s/%s',date{1,1}{3},date{1,1}{2},date{1,1}{1});
  end

Could someone help me to modify the code further to

1) To change the position of date
2) save the updated values to the .txt file

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

请先登录，再进行评论。

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

Answer 1

Alfonso Nieto-Castanon 2014-7-16

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/142018-regexp-and-string-rearrange-in-text-file#answer_145306

编辑：Alfonso Nieto-Castanon 2014-7-16

在 MATLAB Online 中打开

something along these lines:

 % reads file into cell array
 lines = textread('lsit2.txt','%s','delimiter','\n','whitespace','');
 % changes format
 lines = regexprep(lines, '(.*)-(\d+)-(\d+)-(\d+)','$4/$3/$2 $1');
 % saves new file
 f = fopen('newfile.txt','wt'); 
 fprintf(f,'%s\n',lines{:});
 fclose(f);