How do I separate a string with hyphen and colon separation within cell

Question

Bhowmik.U 2019-4-15

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/456472-how-do-i-separate-a-string-with-hyphen-and-colon-separation-within-cell

评论： Bhowmik.U 2019-4-18

RD-180531-160600.txt

When I am trying to read the file enclosed using the code below, the 1st and 2nd entries I am getting is an array of cells

with yyyy-mm-dd

and second with HH:MM:SS

I wish if there were any novel ways to get an array of cells separately with yyyy mm dd (without hyphen) and HH MM and SS (without :)

stated simply I wish I could have a work around to remove hyphen and colon and get each srting separate withing the cells.

Sorry if I sound gibberish!

code:

close all;
clear all;
fileID=fopen('RD-180531-160600.txt');
C=textscan(fileID,'%s%s%f%f%f%f%f%f%f%f%f%f%f%f%f%f%f%f%f%f%f%f%f%7.4f%7.4f%7.4f%[^\n]','HeaderLines',1);
fclose(fileID)
whos C

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

请先登录，再进行评论。

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

Answer 1

Rik 2019-4-15

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/456472-how-do-i-separate-a-string-with-hyphen-and-colon-separation-within-cell#answer_370711

在 MATLAB Online 中打开

If you know the pattern you can simply use that to edit the FormatSpec:

fileID=fopen('RD-180531-160600.txt');
FormatSpec='%4s-%2s-%2s %2s:%2s:%2s %f%f%f%f%f%f%f%f%f%f%f%f%f%f%f%f%f%f%f%f%f%7.4f%7.4f%7.4f%[^\n]';
C=textscan(fileID,FormatSpec,'HeaderLines',1);
fclose(fileID);
whos C