How to reform cell into a vector of strings and text

Question

Lucas Maes 2021-10-21

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1568783-how-to-reform-cell-into-a-vector-of-strings-and-text

评论： Lucas Maes 2021-10-22

Hi, I want to read in a excel with the first cell of each row of the form:

2020-09-02 00:00:00.7770000,"OLW218","Pickling","Water lock  Off-time PV (Sec)",105,,,"Good" 

(this is all in one cell)

and replace it with a vector of the form

[0.777,"OLW218","Pickling","Water lock Off-time PV (Sec)",105,"Good"]

or a form where I can for example have: vector(6) = "Good".

If I use xlsread or save the excel as txt file it is imported as a cell {"2020-09-02 00:00:00.7770000,"OLW218","Pickling","Water lock Off-time PV (Sec)",105,,,"Good""}. I tried the split command, but I can't get the result I want.

2 个评论
显示无隐藏无

dpb 2021-10-21

Why don't you use the Excel whizard and convert/split the text there, just out of curiosity?

How did the file get created in this manner in the first place?

The easiest problem to solve is the one that don't create in the first place...going back to the beginning might be the simplest fix.

Lucas Maes 2021-10-22

Hi dpb

That is an option, but there are a lot of files and I don't want to change them all manually. Creating them differently might be the easiest option, but I don't control that haha.

请先登录，再进行评论。

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

Answer 1

dpb 2021-10-21

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1568783-how-to-reform-cell-into-a-vector-of-strings-and-text#answer_813533

在 MATLAB Online 中打开

Two of many ways to deal with the cellstr --

As string array

>> S=string(split(C,',')); S=S(S~="")
S = 
  6×1 string array
    "2020-09-02 00:00:00.7770000"
    ""OLW218""
    ""Pickling""
    ""Water lock  Off-time PV (Sec)""
    "105"
    ""Good""
>>

or as cellstr

>> CC(~cellfun(@isempty,CC))
ans =
  6×1 cell array
    {'2020-09-02 00:00:00.7770000'    }
    {'"OLW218"'                       }
    {'"Pickling"'                     }
    {'"Water lock  Off-time PV (Sec)"'}
    {'105'                            }
    {'"Good"'                         }
>> 