Split column by text and numbers

3 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)

Categories

Find more on Earth and Planetary Science in Help Center and File Exchange

Products


Release

R2022a

Community Treasure Hunt

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

Start Hunting!