How to get the number in the cell containing the letter and space

1 次查看（过去 30 天）
eko supriyadi
eko supriyadi 2022-6-1
评论： dpb 2022-6-2
Hi everyone
consider i have cell matrix like this:
a={'AABB 01001';'AACC 01101'; 'AACC 01201'; 'AADD 01301'; 'AAEE 01401'}
so, it will produce:
a =
5×1 cell array
{'AABB 01001' }
{'AACC 01101' }
{'AACC 01201' }
{'AADD 01301' }
{'AAEE 01401'}
Now, I have no idea how to take the numbers only (because contain letter and single-multiple space).. so i want the result is (with leading zeros in a number too):
a = 01001
01101
01201
01301
01401
the a result is double format.
thank you for your help :)
  4 个评论
显示 2更早的评论
dpb
dpb 2022-6-1
>> compose('%05d',str2double(extractAfter(a,' ')))
ans =
5×1 cell array
{'01001'}
{'01101'}
{'01201'}
{'01301'}
{'01401'}
>>
Stephen23
Stephen23 2022-6-2
"with leading zeros in a number too"
No numeric class on any common computer platform stores leading zeros, so what you ask for is not possible.
You could store the data as text, in which case you can keep the leading zeros.

请先登录，再进行评论。

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

采纳的回答

Stephen23
Stephen23 2022-6-2
编辑：Stephen23 2022-6-2
Ran in:
No indirect, fragile, round-about conversion to other data classes is required. Here are two direct approaches:
a = {'AABB 01001';'AACC 01101'; 'AACC 01201'; 'AADD 01301'; 'AAEE 01401'}
a = 5×1 cell array
{'AABB 01001' } {'AACC 01101' } {'AACC 01201' } {'AADD 01301' } {'AAEE 01401'}
b = extract(a,digitsPattern)
b = 5×1 cell array
{'01001'} {'01101'} {'01201'} {'01301'} {'01401'}
b = regexp(a,'\d+','match','once')
b = 5×1 cell array
{'01001'} {'01101'} {'01201'} {'01301'} {'01401'}

更多回答（1 个）

dpb
dpb 2022-6-1
编辑：dpb 2022-6-1
>> str2double(extractAfter(a,' '))
ans =
1001
1101
1201
1301
1401
>>
ADDENDUM:
>> compose('%05d',str2double(extractAfter(a,' ')))
ans =
5×1 cell array
{'01001'}
{'01101'}
{'01201'}
{'01301'}
{'01401'}
>>
or
>> string(compose('%05d',str2double(extractAfter(a,' '))))
ans =
5×1 string array
"01001"
"01101"
"01201"
"01301"
"01401"
>>
  2 个评论
eko supriyadi
eko supriyadi 2022-6-1
编辑：eko supriyadi 2022-6-1
b=str2double(extractAfter(a,' '))
for i=1:length(b)
zeroleading(i,:)=sprintf('%05d',b(i))
end
if i want keep zero, is the loop above correct?
dpb
dpb 2022-6-2
If you don't need the numeric values as numeric, there's no point in converting them to numeric just to return them back to string or cellstr() to have the leading zero to display. In that case just extract the numeric pattern in one form or another -- I used the simplest syntax possible, the pattern or regular expression offers more generality.
If want a char() array instead, then just convert directly --
>> char(strtrim(extractAfter(a,' ')))
ans =
5×5 char array
'01001'
'01101'
'01201'
'01301'
'01401'
>>

请先登录，再进行评论。

类别

在 Help Center 和 File Exchange 中查找有关 Cell Arrays 的更多信息

标签

产品


版本

R2021b

Community Treasure Hunt

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

Start Hunting!

Translated by