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

I need to combine all the data in the workspace above so i created a excel as follows

filename = 'testdata.xlsx';

xlswrite(filename,[F,G,H,I,J,K,L,M,N,O,P,Q]);

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.

[madhan ravi]

Wasn't the first question in your previous question?

Answer 1

[YT]

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';

[Rakesh Yadav Kodari]

Thankyou