Split column in table based on character
4 ビュー (過去 30 日間)
古いコメントを表示
Hi,
I have a table with a string column. Now i want to split this column in 3 seperate coluns.
In that column are strings like this:
["51∞ 13' 51,6""]
I want to create new columns like:
[51],[13], [51.6]
Anyone who can help me with this?
0 件のコメント
採用された回答
Walter Roberson
2021 年 8 月 3 日
S = "51∞ 13' 51,6"""
str2double(regexp(regexprep(S, ',', '.'),'[\d.]+', 'match'))
Is it possible for + or - to appear? How is N vs S or E vs W denoted?
3 件のコメント
Walter Roberson
2021 年 8 月 3 日
S = [
"51∞ 14' 12,9"""
"51∞ 8' 40,2"""
"51∞ 16' 43,3"""
"51∞ 8' 40,3"""
]
cell2mat(cellfun(@str2double,regexp(regexprep(S, ',', '.'),'[\d.]+', 'match'), 'uniform', 0))
その他の回答 (0 件)
参考
カテゴリ
Help Center および File Exchange で Logical についてさらに検索
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!