How to split a column in a table into two columns by a space

I have a table of 4 columns. One column is datetime, '2016-02-01 20:48:58.0000000' I would like to split the date and time into two columns. How to do that? Thanks!

Jennifer

Answer 1

[Image Analyst]

Here's one way:

% Create table.
for k = 1 : 3
  ca{k} = datestr(now)
  pause(1.1)
end
% Create table with two columns, initialized to the same for now.
t = table(ca', ca')

% NOW START:
% Split column #1 into columns 1 and 2.
for k = 1 : size(t, 1)
  thisString = cell2mat(t{k,1});
  t{k, 1} = {thisString(1:11)};
  t{k, 2} = {thisString(13:end)};
end
% Show new t in command window.
t

[JFz]

Thanks. It works! But now, my table has thousands of rows. Is there a way to make a varfun or something similar to split that column to make it run fast?

Answer 2

[Ahmet Cecen]

strsplit is your friend:

http://www.mathworks.com/help/matlab/ref/strsplit.html

[JFz]

Thanks. Should I apply this as a function to the column?

Answer 3

[Peter Perkins]

If the variable in your table is literally a datetime, and not a cellstr containing datestrs, then you'll want to split them uing timeofday to get the time part, and dateshift to get the date part.

[JFz]

Thanks! I will try that. In the mean time, is there anyway to avoid the for loop, such as something like varfun to make it run in a blast?