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 vue (au cours des 30 derniers jours)
Afficher commentaires plus anciens
Rakesh Yadav Kodari
le 4 Fév 2019
Commenté : Rakesh Yadav Kodari
le 4 Fév 2019
![workspace.PNG](https://www.mathworks.com/matlabcentral/answers/uploaded_files/202652/workspace.png)
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]);
- I need to remove all "/" from the data
- 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 commentaire
Réponse acceptée
YT
le 4 Fév 2019
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';
Plus de réponses (0)
Voir également
Catégories
En savoir plus sur Workspace Variables and MAT-Files dans Help Center et File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!