1 field in 2 columns Load?

[tomcatxx]

Hello, there.

I have a question.

One filed of my table.csv is called  Time.  It looks like so.

Time
12/3/2015 01:21
2/6/2014 00:23
3/11/2015 00:18
...
...
...

I want to load 'Time' in two columns like this.

date	time
12/03/2015	01:21
02/06/2014	00:23
03/11/2015	00:18
...	...
...	...
..	...

I dont know how to make '12/3/2015' to '12/03/2015'. I cant use Left() to select date, because the Byte length of date in my csv is not same.

[vishsaggi]

may be one option :

DateField:
LOAD *, Timestamp(Timestamp#(DateTimeField, 'MM/DD/YYYY hh:mm'), 'hh:mm') AS TimeStamp,
Date(Date#(DateTimeField, 'MM/DD/YYYY hh:mm'), 'MM/DD/YYYY') AS DateStamp INLINE [
DateTimeField
12/3/2015 01:21
2/6/2014 00:23
3/11/2015 00:18
];