Split data from one excel cell file into 2 columns
1 visualizzazione (ultimi 30 giorni)
Mostra commenti meno recenti
Hello,
I am dealing with an excel column that you could see below where I would like to spit it in two different columns one that includes the text before the / and one that includes the text after the /?
Is there an easy way to do that?
![](https://www.mathworks.com/matlabcentral/answers/uploaded_files/231993/image.png)
Thanks in advance
Greg
5 Commenti
Guillaume
il 31 Lug 2019
Modificato: Guillaume
il 31 Lug 2019
I don't know about split since you can't see its code (at least the useful part), but the older strsplit is just a wrapper for regexp, so they're pretty much equivalent anyway. split/strsplit has the advantage you don't need to learn regular expressions.
Bob Thompson
il 31 Lug 2019
I might be slightly bias, but I think that if you spend any amount of time regularly working with strings in Matlab it is totally worth it to learn regexp. There is definitely a bit of a learning curve, but it's such a useful tool. strsplit is definitely easier to pick up and use in a pinch though.
Risposte (0)
Vedere anche
Categorie
Scopri di più su Characters and Strings in Help Center e File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!