清空筛选条件
清空筛选条件

how to convert a column of cells into string?

3 次查看（过去 30 天）
Amr Hashem
Amr Hashem 2015-5-19
编辑： per isakson 2015-5-20
when i try my code ( search for a word in a cells of column), i use :
% search for "battery" in column 52th
B=~cellfun('isempty',regexp(alldata(:,52),'BATTERY'))
i got an error : All cells must be strings.
B=~cellfun('isempty',regexp(alldata(:,52),'BATTERY'))
how i can solve this?
note: the column contain a texts but some cells is empty or contain NaN

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

采纳的回答

per isakson
per isakson 2015-5-19
编辑：per isakson 2015-5-19
NaN is double
>> class( nan )
ans =
double
replace Nan by '' (empty string)
>> alldata = {'abc', nan, 'def'}
alldata =
'abc' [NaN] 'def'
>> alldata{ not( cellfun( @ischar, alldata ) ) } = '';
>> alldata
alldata =
'abc' '' 'def'
  2 个评论
Amr Hashem
Amr Hashem 2015-5-19
how i can do a for loop on a column of cells which some are not string to make them string
per isakson
per isakson 2015-5-20
编辑：per isakson 2015-5-20
>> alldata{ not( cellfun( @ischar, alldata ) ) } = '';
does that. Why use a loop?
any_string_value = 'abc';
for jj = 1 : length( alldata )
if not( ischar( alldata{jj} ) )
alldata{jj} = any_string_value;
end
end

请先登录，再进行评论。

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Characters and Strings 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by