Split column in table based on character

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?

Answer 1

[Walter Roberson]

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?

[Dion Theunissen]

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]

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]

 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