Split column in table based on character

6 次查看（过去 30 天）
Dion Theunissen
Dion Theunissen 2021-8-3
评论： Walter Roberson 2021-8-3
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?

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

采纳的回答

Walter Roberson
Walter Roberson 2021-8-3
Ran in:
S = "51∞ 13' 51,6"""
S = "51∞ 13' 51,6""
str2double(regexp(regexprep(S, ',', '.'),'[\d.]+', 'match'))
ans = 1×3
51.0000 13.0000 51.6000
Is it possible for + or - to appear? How is N vs S or E vs W denoted?
  3 个评论
显示 1更早的评论
Dion Theunissen
Dion Theunissen 2021-8-3
I have some issues with converting the values into a double or table. If I convert it to a double, i got NaN's. If I convert it to a table it results in 3 values and coluns in 1 column.
Walter Roberson
Walter Roberson 2021-8-3
Ran in:
S = [
"51∞ 14' 12,9"""
"51∞ 8' 40,2"""
"51∞ 16' 43,3"""
"51∞ 8' 40,3"""
]
S = 4×1 string array
"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))
ans = 4×3
51.0000 14.0000 12.9000 51.0000 8.0000 40.2000 51.0000 16.0000 43.3000 51.0000 8.0000 40.3000

请先登录，再进行评论。

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Logical 的更多信息

标签

产品


版本

R2021a

Community Treasure Hunt

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

Start Hunting!

Translated by