How can I split comma-separated characters inside a cell of a cell array?

4 次查看（过去 30 天）

显示更早的评论

Thisis Idea 2023-11-12

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/2046120-how-can-i-split-comma-separated-characters-inside-a-cell-of-a-cell-array

回答： Jeremy Hughes 2024-1-4

I have Cell array element extracted from xls file as

C={'NORMAL,HI,LOW,MEDIUM,OUTOFR'}

first I want to count the words with delimeter as",", then assign values to these as

NORM=0

LOW=1

HI=2

MEDIUM=3

OUTOFR=4

I tried strsplit by converting the cell to string but it gave same string as

"NORM,HI,LOW,MEDIUM,OUTOFR"

6 个评论
显示 4更早的评论隐藏 4更早的评论

Stephen23 2023-11-12

编辑：Stephen23 2023-11-12

"About assigning variables ..no i am not doing it dynamically. I call these splitted words as values and I will assign the numbers to the words in alphabetical order."

That sounds exactly like dynamically creating variable names using meta-data (and is also what you show in your question).

A table may be a good choice for that data.

Kyle 2023-11-18

@Thisis Idea

How are you getting this cell array from the .xls file? It sounds like you might be able to simplify your code a lot if you let MATLAB import the data for you. You could use the Import Tool or Live Editor Import Data task and either will give you reusable code to import from that file programatically. Alternatively, if you already know your data, you could also write your own code using readtable to import data with row names.

请先登录，再进行评论。

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

回答（1 个）

Jeremy Hughes 2024-1-4

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/2046120-how-can-i-split-comma-separated-characters-inside-a-cell-of-a-cell-array#answer_1383196

在 MATLAB Online 中打开

C={'NORMAL,HI,LOW,MEDIUM,OUTOFR'}
C = 1×1 cell array
    {'NORMAL,HI,LOW,MEDIUM,OUTOFR'}
split(C,",")
ans = 5×1 cell array
    {'NORMAL'}
    {'HI'    }
    {'LOW'   }
    {'MEDIUM'}
    {'OUTOFR'}