Split data from one excel cell file into 2 columns

Grigorios Kyritsakas

2019 7 31

0 个回答

1 次查看（30 天）

0 个投票

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 个评论
显示 3更早的评论隐藏 3更早的评论

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.

请先登录，再进行评论。

请先登录，再回答此问题。

Follow Question