General Discussions

Discuss any topics that are not product-specific here.
SOLVED

Separating Date & Time

Cherkos12
7 - Meteor

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

 

 

Cherkos12_0-1658780418557.png

 

2 REPLIES 2
DataNath
14 - Magnetar

Hey @Cherkos12 how does this look?

 

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

 

DataNath_0-1658782761954.png

 

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

 

DataNath_1-1658782913029.png

 

Workbook attached.

Cherkos12
7 - Meteor

this helped. thanks

Labels