Seperate Date,Time & Country

[DipeshVadgama]

Hi,

How to Separate date, Time & Country in load

My Data contains like below

13/Apr/2017 19:32 Europe/London

01/Jul/2017 Asia/Calcutta

[sunny_talwar · Accepted solution]

May be like this

Date#(SubField(FieldName, ' ', 1), 'DD/MMM/YYYY') as Date,

Time#(SubField(FieldName, ' ', 2), 'hh:mm') as Time,

SubField(FieldName, ' ', 3) as Country

[Clever_Anjos]

Sufield(yourfield,' ',1) as Date,

Sufield(yourfield,' ',-1) as Country,

If( Sufield(yourfield,' ',-1)  <> Sufield(yourfield,' ',2),Sufield(yourfield,' ',2)) as Time

[DipeshVadgama]

Thanks Your both function works