Separating Date & Time

[Cherkos12]

Hi -

the 'completed time' field is vstring type which wouldn't let me force to change the data type and wanting to parse that field into 2 separate fields, date and time. please help

Thanks

[DataNath · Accepted solution]

Hey @Cherkos12 how does this look?

([0-9-]+)(.+)

In the above example, I've just split them and left the fields as they come out. However, if you want just the raw time for example then you can change the expression to something like the following:

([0-9-]+)T(.{8})

Workbook attached.

[Cherkos12]

this helped. thanks