How to covert all table entries to non-cell?

3 views (last 30 days)
Atanu
Atanu on 17 Mar 2022
Commented: Atanu on 18 Mar 2022
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?

Answers (1)

KSSV
KSSV on 17 Mar 2022
Two options.
  1. While reading the table, you can specify the format of each column and read it. Read about the detectImportOptions.
  2. After reading the table, you can convert to the format you want. Read about datetime, str2num, str2double, etc.
  1 Comment
Atanu
Atanu on 18 Mar 2022
Thanks for your comment. But I have the table already in the workspace. So I had to convert the data from the workspace.

Sign in to comment.

Products


Release

R2022a

Community Treasure Hunt

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

Start Hunting!