MATLAB Answers

Please Help me to combine the following data, Cut the data from the combined data and form a new data (screen shots are attached)

1 ビュー (過去 30 日間)
Rakesh Yadav Kodari
Rakesh Yadav Kodari 2019 年 2 月 4 日
I need to combine all the data in the workspace above so i created a excel as follows
filename = 'testdata.xlsx';
  1. I need to remove all "/" from the data
  2. I need to cut the data which starts with "M" and Ends with symbol "|" and save it as new data
Please help me regarding the same.
Thank you in advance.

  1 件のコメント

madhan ravi
madhan ravi 2019 年 2 月 4 日
Wasn't the first question in your previous question?



YT 2019 年 2 月 4 日
You can use strrep to replace the forward slashes and then use regular expressions to capture the characters.
A = '/FF0A/-MFF0/-LDAO/-FF91/-F98D/|/-F860';
res = regexp(strrep(A,'/',''),'.*(M.*)\|','tokens');
% res{:}{:} = 'MFF0-LDAO-FF91-F98D';

その他の回答 (0 件)

Community Treasure Hunt

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

Start Hunting!

Translated by