How to replace matrix value with string from cell array?

2018 10 1
2 个回答
回答已采纳
更新时间：2018 10 2
5 次查看（30 天）

0 个投票

I have a cell array of string and a data matrix. How do I replace the value in the data matrix with the strings marked by ‘#’. I want the output to be a cell array of strings like the “output” in the script below.

cell = {
    '# 2.537'    '1.219'      '0.457'    '0.214'    '# 0.120'    '0.245'
    '3.244'      '# 1.400'    '0.649'    '0.515'    '0.207'      '0.075'
    '2.993'      '1.282'      '0.605'    '0.309'    '0.140'      '0.140'
    '3.278'      '1.507'      '0.885'    '0.405'    '0.160'      '0.111'
    '3.691'      '1.474'      '0.650'    '0.316'    '0.180'      '0.155'}

data=[
    0.8147    0.0975    0.1576    0.1419    0.6557    0.7577
    0.9058    0.2785    0.9706    0.4218    0.0357    0.7431
    0.1270    0.5469    0.9572    0.9157    0.8491    0.3922
    0.9134    0.9575    0.4854    0.7922    0.9340    0.6555
    0.6324    0.9649    0.8003    0.9595    0.6787    0.1712]

output={
    '# 2.537'   '0.0975'    '0.1576'    '0.1419'    '# 0.120'   '0.7577'
    '0.9058'    '# 1.400'   '0.9706'    '0.4218'    '0.0357'    '0.7431'
    '0.1270'    '0.5469'    '0.9572'    '0.9157'    '0.8491'    '0.3922'
    '0.9134'    '0.9575'    '0.4854'    '0.7922'    '0.9340'    '0.6555'
    '0.6324'    '0.9649'    '0.8003'    '0.9595'    '0.6787'    '0.1712'}

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

 采纳的回答

Jan
Jan 2018-10-2

1 个投票

output = sprintfc('%.4f', data);
index = strncmp(c, '#', 1);
output(index) = c(index);

更多回答（1 个）

jonas
jonas 2018-10-1
编辑：jonas 2018-10-1

0 个投票

Cell is a built in function so avoid using it as a variable name. Anyway, you can try this:
mask=logical(count(cell,'#'))
data=cellstr(string(a))
data(mask)=cell(mask)
data =
5×6 cell array
{'# 2.537'} {'0.0975' } {'0.1576'} {'0.1419'} {'# 0.120'} {'0.7577'}
{'0.9058' } {'# 1.400'} {'0.9706'} {'0.4218'} {'0.0357' } {'0.7431'}
{'0.127' } {'0.5469' } {'0.9572'} {'0.9157'} {'0.8491' } {'0.3922'}
{'0.9134' } {'0.9575' } {'0.4854'} {'0.7922'} {'0.934' } {'0.6555'}
{'0.6324' } {'0.9649' } {'0.8003'} {'0.9595'} {'0.6787' } {'0.1712'}

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

Johnny Birch
Johnny Birch 2018-10-1
编辑：Johnny Birch 2018-10-1
Hi Jonas, thanks a lot for your answer. I changed the "cell" to "c", but I get this error:
Undefined function 'count' for input arguments of type 'cell'.
mask=logical(count(c,'#'))

请先登录，再进行评论。

类别

在 帮助中心 和 File Exchange 中查找有关 Characters and Strings 的更多信息

产品

版本

R2015b

标签

Community Treasure Hunt

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

Start Hunting!

Translated by