Split column by text and numbers

5 visualizzazioni (ultimi 30 giorni)
Dion Theunissen
Dion Theunissen il 10 Ago 2022
Risposto: Stephen23 il 10 Ago 2022
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 Commento
Walter Roberson
Walter Roberson il 10 Ago 2022
https://www.mathworks.com/help/matlab/ref/extract.html

Accedi per commentare.

Risposta accettata

Stephen23
Stephen23 il 10 Ago 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"

Più risposte (0)

Prodotti


Release

R2022a

Community Treasure Hunt

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

Start Hunting!

Translated by