Split data from one excel cell file into 2 columns
1 view (last 30 days)
Show older comments
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 Comments
Guillaume
on 31 Jul 2019
Edited: Guillaume
on 31 Jul 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
on 31 Jul 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.
Answers (0)
See Also
Categories
Find more on Characters and Strings in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!