How can I transform two values separted by _ of one colum in two columns?

Hallo,

I have one column with two values separated by _ e.g. '78.5888_2.027'.

The aim is to separate these alue sin two columns making pltotting of value one against two possible.

Thank you fro your help,

Answer 1

[madhan ravi]

s='78.5888_2.027'
str2double(regexp(s,'\d+[\.?]\d*','match'))

[Kirsten Purschke]

Thank you,

for this example it works but for my table colum the result will be NaN.

[madhan ravi]

Upload your table as .mat file.

[Kirsten Purschke]

Here is the tabe as .mat file

[madhan ravi]

Could you post a screenshot? I'm having trouble downloading the file.

[Kirsten Purschke]

screenshot

[madhan ravi]

cell2mat(cellfun(@(x)str2double(regexp(x,...
    '\d+[\.]?\d*','match')),...
        table2cell(T),'un',0)) % where T is n by 1 table assuming from the picture

Answer 2

[Dawn MacIsaac]

You can also use strsplit in combination with str2double(), but you would have to loop through each row in the table.

Answer 3

[Star Strider]

This seems to work:

D = load('F.mat');
F = D.F;
for k = 1:size(F,1)
    d(k,:) = sscanf(F{k},'%f_%f');
end

The loop is necessary because of the nature of ‘F’.

[Kirsten Purschke]

Jeah that works. Thank you!

[Star Strider]

My pleasure!

If my Answer helped you solve your problem, please Accept it!

Answer 4

[Adam Danz]

Here's a one-liner. No loop needed.

xy = cell2mat(cellfun(@str2num, strtrim(regexprep(F,'[^0-9.]',' ')), 'UniformOutput', false));

xy(:,1) These are your x coordinates

xy(:,2) These are your y coordinates

Tested on your mat file.