How can I split up several data (string, number) in one cell from an excel file?

Question

Victor Szenes 2021-4-6

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/794477-how-can-i-split-up-several-data-string-number-in-one-cell-from-an-excel-file

回答： Arjun 2025-6-10

Hello community,

I am new to matlab and I imported an excel file which includes data of string, number and dates (all data are in the same column) and I want to split it into 3 columns.

Information of the data:

example:

Person XYZ
12345678
01.01.1990
Person ABC
19876543
01.11.1995

and I want to "transpose" the data like that:

column 1        column 2       column 3
Person XY     12345678    01.01.1990
Person ABC   19876543    01.11.1995

I think its not that difficult to solve this problem, I already tried so solve it with a for loop and if statement but I have some problems to get the right syntax.

Thanks in advance!

stay safe!!! :-)

2 个评论
显示无隐藏无

Bob Thompson 2021-4-6

If you use cells to store you data, then you should be able to use reshape to reorganize the data.

dpb 2021-4-7

And, in fact, given the mixed content in the file, you'll get a column of cellstr() when you read the Excel file automagically so really have almost nothing left to do! :)

请先登录，再进行评论。

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