Remove String and extract numbers to move to new column

Question

Lukas Netzer 2021-8-4

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/892012-remove-string-and-extract-numbers-to-move-to-new-column

评论： Lukas Netzer 2021-8-4

I have a column like that:

WPS
"[0, 0]"
"[0, 5]"
"[5, 115]"
"[115, 219]"
"[219, 262]"
"[262, 328]"
"[328, 408]"
"[408, 424]"
"[424, 531]"
"[531, 562]"

Now for me to be able to further work with that, I would like to move the first and the second number in each of the strings to seperate new columns, which should look like that:

WP1     WP2 
     0
     5
     115
   219
   262
   328
   408
   424
   531
   562

Now I found out that it somehow can be done with regular expressions, but I can not really figure out how. I'm thinking I need to use str2num but this would not work, as my string still contains brackets - any hint is appreciated - thank you!

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

Answer 1

Stephen23 2021-8-4

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/892012-remove-string-and-extract-numbers-to-move-to-new-column#answer_760452

S = [...
"[0, 0]"
"[0, 5]"
"[5, 115]"
"[115, 219]"
"[219, 262]"
"[262, 328]"
"[328, 408]"
"[408, 424]"
"[424, 531]"
"[531, 562]"];
M = sscanf([S{:}],'[%f,%f]',[2,Inf]).'
M = 10×2
     0     0
     0     5
     5   115
   115   219
   219   262
   262   328
   328   408
   408   424
   424   531
   531   562