Split column by text and numbers

2 views (last 30 days)
I have a column with housenumbers. Like:
str = ["54","33", "104A",...]
I want to split it in two columns
Numbers = ["54","33", "104",...]
Letters = ["","", "A",...]
  1 Comment
Walter Roberson
Walter Roberson on 10 Aug 2022
https://www.mathworks.com/help/matlab/ref/extract.html

Sign in to comment.

Accepted Answer

Stephen23
Stephen23 on 10 Aug 2022
str = ["54","33","104A"];
tkn = regexp(str,'^(\d+)\s*(\w*)$','tokens','once');
tkn = vertcat(tkn{:});
num = tkn(:,1)
num = 3×1 string array
"54" "33" "104"
let = tkn(:,2)
let = 3×1 string array
"" "" "A"

More Answers (0)

Products


Release

R2022a

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!