Split column in table based on character

2021 8 3
1 个回答
回答已采纳
更新时间：2021 8 3
4 次查看（30 天）

0 个投票

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:

0 个投票

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更早的评论 隐藏 1更早的评论

Dion Theunissen
Dion Theunissen 2021-8-3
编辑：Dion Theunissen 2021-8-3
Yes it is possible, Actually in my case, everything is possitive.
If i try your solution i only got NaN values
S =
"51∞ 14' 12,9""
"51∞ 8' 40,2""
"51∞ 16' 43,3""
"51∞ 8' 40,3""
ans =
NaN
NaN
NaN
NaN
I see in your example there is 1 " more on the end. What do I have to change to get the same result?
Thanks!
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:
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 个）

类别

在 帮助中心 和 File Exchange 中查找有关 Tables 的更多信息

产品

版本

R2021a

标签

Community Treasure Hunt

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

Start Hunting!

Translated by