Split data from one excel cell file into 2 columns
조회 수: 1 (최근 30일)
이전 댓글 표시
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?
Thanks in advance
Greg
댓글 수: 5
Guillaume
2019년 7월 31일
편집: Guillaume
2019년 7월 31일
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
2019년 7월 31일
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.
답변 (0개)
참고 항목
카테고리
Help Center 및 File Exchange에서 Logical에 대해 자세히 알아보기
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!