Convert a table column of mixed data type to one data type

5 ビュー (過去 30 日間)
JFz 2016 年 6 月 16 日
回答済み: Kirby Fears 2016 年 6 月 16 日
I have a table column that has both integers and strings. The integers are for dates. I would like to convert the integers to dates and then dates to strings.
How to do that?
Thanks in advance!
  1 件のコメント
James Tursa
James Tursa 2016 年 6 月 16 日
Please post a small example, showing exactly what you have in the column and what the desired output would be. Specifically, what is the integer value and how is it related to a date?


回答 (1 件)

Kirby Fears
Kirby Fears 2016 年 6 月 16 日
Here's an example using a cell mixed type cell array "Var1" in table "t". You should be able to solve your problem with a similar approach.
t = cell2table({'date1',736495,'date2',736496,'date3',736497}');
ix = cellfun(@isnumeric,t.Var1);
t.Var1(ix) = cellfun(@(x)datestr(x,'yyyymmdd'),t.Var1(ix),'UniformOutput',false);



Community Treasure Hunt

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

Start Hunting!

Translated by