extract numbers from cells

I have a cell array with n rows wich contains:

'Gain=2M'

'Gain=500k'

'Gain=20M'

....

I would extract only the number which is contained in each cell. How can I do that?

[KSSV]

Read about regexp

Answer 1

[Chunru]

s={'Gain=2M'
'Gain=500k'
'Gain=20M'};

n = length(s);
g = zeros(n, 1);
for i=1:n
    tmp = strrep(s{i}, 'Gain=', '');
    g(i) = str2num(tmp(1:end-1));
    switch tmp(end)
        case 'M'
            g(i)=g(i)*1e6;
        case 'k'
            g(i)=g(i)*1e3;
    end
end
g

g = 3×1

2000000 500000 20000000

[alessio tugnolo]

Great! It works beautifully!

Thanks

Answer 2

[Stephen23]

Simply download my FEX submission SIP2NUM:

https://www.mathworks.com/matlabcentral/fileexchange/53886-scientific-prefix-to-number

and use it like this:

C = {'Gain=2M';'Gain=500k';'Gain=20M'};
V = cellfun(@sip2num,C)

V = 3×1

2000000 500000 20000000

[alessio tugnolo]

Thank you !