フィルターのクリア

How can I extract an array of numbers from a text-formatted cell array of strings.

2 ビュー (過去 30 日間)
dormant
dormant 2024 年 4 月 26 日
回答済み: dormant 2024 年 5 月 14 日
I have read some data from a spreadsheet. The values are times, but formatted with s, m or h as a suffix to indicate seconds, minutes or hours. see example below,
I'd like to convert all of them to seconds, with NaN for the blank ones.
Is there an elegant way to do this?
Like this:
{'20s' }
{'15m' }
{0×0 char }
{'24s' }
{0×0 char }
{'44s' }
{'3h' }
{'40m' }
{'20s' }
{0×0 char }
{'14s' }

採用された回答

Stephen23
Stephen23 2024 年 4 月 26 日
編集済み: Stephen23 2024 年 4 月 26 日
C = {'20s';'15m';'';'24s';'';'44s';'3h';'40m';'20s';'';'14s'}
C = 11x1 cell array
{'20s' } {'15m' } {0x0 char} {'24s' } {0x0 char} {'44s' } {'3h' } {'40m' } {'20s' } {0x0 char} {'14s' }
F = @(t)prod(sscanf(t,'%f'));
V = cellfun(F,regexprep(C,{'h$','m$','^$'},{' 3600',' 60','NaN'},'emptymatch'))
V = 11x1
20 900 NaN 24 NaN 44 10800 2400 20 NaN
<mw-icon class=""></mw-icon>
<mw-icon class=""></mw-icon>

その他の回答 (2 件)

Voss
Voss 2024 年 4 月 26 日
data = {
'20s'
'15m'
''
'24s'
''
'44s'
'3h'
'40m'
'20s'
''
'14s'
};
C = regexp(data,'(\d+)([hms])','tokens','once');
idx = ~cellfun(@isempty,C);
C = vertcat(C{idx});
val = str2double(C(:,1));
[~,unit] = ismember(C(:,2),{'s','m','h'});
result = NaN(size(data));
result(idx) = val.*60.^(unit-1);
disp(result)
20 900 NaN 24 NaN 44 10800 2400 20 NaN 14

dormant
dormant 2024 年 5 月 14 日
Thanks. Both of you helped.

製品


リリース

R2024a

Community Treasure Hunt

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

Start Hunting!

Translated by