How to covert all table entries to non-cell?

Question

Atanu 2022-3-17

评论： Atanu 2022-3-18

I have a table where all the entries are as 1*1 cell array. Here is part of table attached.

test_data.date(1)
ans =
  1×1 cell array
    {'02/10/2022'}

How can I convert all table entries to non cell native data types?

Answer 1

KSSV 2022-3-17

Two options.

While reading the table, you can specify the format of each column and read it. Read about the detectImportOptions.
After reading the table, you can convert to the format you want. Read about datetime, str2num, str2double, etc.

Atanu 2022-3-18

Thanks for your comment. But I have the table already in the workspace. So I had to convert the data from the workspace.