Thank you very much for the reply, the code works very well, but the datetime of this 2019-12-02T07:55:01.120950718+01 has missing time variable after spliting into date column and time column. So I wish to maintain the datetime format in the first row same as the second row, before spliting it into date and time. please how do I do it. #RIC Domain Date-Time Type Bid Price Ask Price 0E64.L Market Price 2019-12-02T07:55:01.120950718Z Quote 79 0E64.L Market Price 2019-12-02T07:55:01.120950718+01 Quote 79 83 ... View more