How to convert string to number and process underscores? (e.g. '57_77_' to 57.77)

Question

Daniel Bridges 2018-3-14

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/388177-how-to-convert-string-to-number-and-process-underscores-e-g-57_77_-to-57-77

评论： Daniel Bridges 2018-3-15

How do you convert a string with underscores to a number, namely '57_77_' to 57.77? What commands would you use?

I am looking through the documentation, e.g. join, compose, sprintf, extractBefore, trying to figure out how to process such a string, namely to execute the steps:

delete final '_'
convert '_' to decimal point '.'
convert string to number

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

Daniel Bridges 2018-3-14

" how to remove last characther from cell array of string" seems to answer #1.

请先登录，再进行评论。

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

Answer 1

Stephen23 2018-3-14

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/388177-how-to-convert-string-to-number-and-process-underscores-e-g-57_77_-to-57-77#answer_309983

编辑：Stephen23 2018-3-14

在 MATLAB Online 中打开

Faster and more efficient than using str2num (which hides a slow eval call inside) is to simply use the low-level function sscanf:

>> sscanf(strrep('57_77_','_','.'),'%f')
ans =  57.770

This is ten times faster than the accepted answer (1e4 iterations):

Elapsed time is 0.277028 seconds. % my code
Elapsed time is 2.63426 seconds.  % accepted answer

5 个评论
显示 3更早的评论隐藏 3更早的评论

Daniel Bridges 2018-3-14

编辑：Daniel Bridges 2018-3-14

在 MATLAB Online 中打开

Replacing str2num with sscanf dropped the execution time from 19 s to 17 s for 40 iterations (apparently my bottleneck is something else -- perhaps reading the CSV files with detectImportOptions). Any thoughts how to further expedite this code? (Edit: I am now reading your other answer which appears also to answer this one.)

function output = GetVolumesFromDVH(organ)
 NoPt = 40;
 output = zeros(NoPt,1);
 searchstring = [organ,'_'];
 for fileloop = 1:NoPt
     filepath = fullfile('DVH','blurred',sprintf('%u.csv',fileloop));
     output(fileloop) = GetOrgVol(filepath,searchstring);
 end
end
function volume = GetOrgVol(filepath,searchstring)
% get list of variable names
opts = detectImportOptions(filepath, 'NumHeaderLines', 1);
% we find the column containing the organ volume
OrganSearching = regexp(opts.VariableNames,searchstring);
for loop = 1:numel(opts.VariableNames)
    if OrganSearching{loop} == 1
        index = loop;
    end
end
% extract volume from said string
volume = extractAfter(opts.VariableNames{index},'Volume_');
volume = sscanf(strrep(volume,'_','.'),'%f');
end

Stephen23 2018-3-14

If the CSV files all have the exactly same format then there is no reason why detectImportOptions has to be called 40 times. Why not move it out of the function, call it once before the loop, and pass that data as an input argument?

Daniel Bridges 2018-3-15

The goal is to read the table variable names in each file: Their order, number, and name differ. So I was thinking I needed to call it each time since the variable names generally differ each time.

Isn't there a better command than detectImportOptions since .VariableNames is all I need?

请先登录，再进行评论。

Answer 2

Birdman 2018-3-14

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/388177-how-to-convert-string-to-number-and-process-underscores-e-g-57_77_-to-57-77#answer_309960

编辑：Birdman 2018-3-14

在 MATLAB Online 中打开

The wise thing would be to first convert underlines to dots by using regexprep or strrep:

a=regexprep(a,'_','.')

or

a=strrep(a,'_','.')

and then delete the last character by

 a(end)=[]
 a=str2num(a)

Other way would be doing this by using regexp:

idx=regexp(a,'_')
a(idx)=['.',' ']
a=str2num(a)

2 个评论
显示无隐藏无

Jos (10584) 2018-3-14

you can remove the last element of the string before the replacement of the underscore ...

Birdman 2018-3-14

Yes, it is up to user.

请先登录，再进行评论。

Answer 3

Jos (10584) 2018-3-14

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/388177-how-to-convert-string-to-number-and-process-underscores-e-g-57_77_-to-57-77#answer_309961

在 MATLAB Online 中打开

all in one go:

a = '12_23_' 
v = str2num(strrep(a(1:end-1), '_', '.'))

2 个评论
显示无隐藏无

Birdman 2018-3-14

You say all in one go but you use two functions in one line, actually it is all in two go :)

Jos (10584) 2018-3-14

haha, actually it is even three if you take indexing into account.

请先登录，再进行评论。

Answer 4

Daniel Bridges 2018-3-14

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/388177-how-to-convert-string-to-number-and-process-underscores-e-g-57_77_-to-57-77#answer_309962

编辑：Daniel Bridges 2018-3-14

在 MATLAB Online 中打开

Here is one method that works, but I am not happy using a cell wrapper just to use Walter Roberson's cellfun; I'm sure there's a better way ...

volume = '57_77_';
volume = cellfun(@(S) S(1:end-1), {volume}, 'Uniform', 0);
volume = volume{1};
volume = regexprep(volume,'_','.');
volume = str2num(volume)

Result:

volume =
   57.7700

4 个评论
显示 2更早的评论隐藏 2更早的评论

Birdman 2018-3-14

That was a misunderstanding, I have just edited it. Sorry for the misunderstanding.

Daniel Bridges 2018-3-14

编辑：Daniel Bridges 2018-3-14

Oh! Sorry for my awkward question -- I accidentally combined Japanese and English grammar. (or else made a Japanese-type English grammar mistake) I will edit my question to clarify, too, if not simply for the sake of English.

请先登录，再进行评论。

How to convert string to number and process underscores? (e.g. '57_77_' to 57.77)

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

采纳的回答

5 个评论
显示 3更早的评论隐藏 3更早的评论

更多回答（3 个）

2 个评论
显示无隐藏无

2 个评论
显示无隐藏无

4 个评论
显示 2更早的评论隐藏 2更早的评论

另请参阅

类别

标签

产品

Community Treasure Hunt

How to convert string to number and process underscores? (e.g. '57_77_' to 57.77)

1 个评论 显示 -1更早的评论隐藏 -1更早的评论

采纳的回答

5 个评论 显示 3更早的评论隐藏 3更早的评论

更多回答（3 个）

2 个评论 显示 无隐藏 无

2 个评论 显示 无隐藏 无

4 个评论 显示 2更早的评论隐藏 2更早的评论

另请参阅

类别

标签

产品

Community Treasure Hunt

WeChat

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

5 个评论
显示 3更早的评论隐藏 3更早的评论

2 个评论
显示无隐藏无

2 个评论
显示无隐藏无

4 个评论
显示 2更早的评论隐藏 2更早的评论