How to separate the combined date-time column in exported CSVs

Follow the below steps to separate the combined date-time column into two individual date and time columns. The following steps will be applicable for LibreOffice Calc for Linux.

Step 1

Open the downloaded CSV file and choose Date (MDY) from the Column type drop-down. Then click OK.

Combined date-time column in exported CSV

Step 2

1. In the new page that opens, select the combined date-time column and navigate to Data on the title bar of the page. 
2. Select Text to Columns and choose Space for the Separated By field. By default, the Tab option will be enabled for the Separated By field, so you'll need to uncheck that after choosing Space. 
3. Choose the Collection Time column and then select Date (MDY) from the Column type drop-down. Once you're done, click OK.
   

 

Choose the column type as Date(DMY).

Now you'll be able to view the date and time in two separate columns, and you can rename them accordingly.

 

​The above steps work for all combined date-time formats.

  

Separate date time column.

 

• Related Articles

• Global Parameters: List of supported Date and Time Components

  To configure a Global Parameter with a strategy Current Date and Time, you must specify the respective Date and Time pattern string in the Parameter Value field. Letters specified in the below table alone can be used to generate the pattern strings. ...

• What are the different global time periods and their relevant duration used by Site24x7's reporting engine?

  Site24x7 provides the following time periods for report generation: Time period Duration used for reporting Last 1 Hour From 60 minutes ago until the current time Last 6 Hours From 6 hours ago until the current time  Last 12 Hours From 12 hours ago ...

• Why is my website response time too high from China?

  If your website is hosted outside China and you have chosen China as the location for monitoring, then the website response time will be high. This is because of the Great Firewall policy followed by China wherein, all the data coming from outside ...

• Getting data for custom time periods in Real User Monitoring

  Site24x7 Real User Monitoring (RUM) now allows you to get stats for custom time periods. All you need to do is define the time period for which you need the data and our dashboard will show metrics only for the period you have defined. The time ...

• API response changes while using Custom Time Period in Reports

  If you've chosen a custom time period for generating a Summary report, Availability Summary report, or Performance report, and the resultant reporting range is equivalent to that of a system-provided time range, then the final API JSON response data ...