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

Hi,

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!

Jennifer

[James Tursa]

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?

Answer 1

[Kirby Fears]

Jennifer,

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);