How to treat csv column as date-time

IttayD Published at Dev

IttayD

I have a CSV file where one of the columns is a string representation of a date in the form 'dd.mm.yy@hh:mm:ss'. I want excel to read this as a date format, so it can sort, filter, etc. How can I do that?

Ron Rosenfeld

Use the Data / Text to columns wizard.

Step 1: Delimited
Step 2: Delimiters Other: @
Step 3: Select the first column (the date part) and for Column Data Format select Date: DMY

You will probably have to reformat the date column by removing the hyperlink and then applying the desired date format

The above could be automated, if necessary.

If you need both in the same column, you can add them.

Collected from the Internet

Please contact [email protected] to delete if infringement.

edited at2021-03-17

Comments

0 comments

How to treat a randomly generated Date as UTC time

How append date info to a time column on read_csv

Separate date and time from csv column

How to split datetime strings column in a .csv file into seperate date and time column?

How do I combine two columns of date and time in a csv file to 1 datetime column in pandas?

how to split date-time and data from same column in csv using python?

How do I make pandas treat each row as a column based on a certain date variable?

How do I combine columns (date, time, year) of a CSV file in the concat format (to create one new date column) and then delete them after?

How to force a CSV column to treat numbers as text, in C# using StringBuilder

How to create a date (column) from a date-time (column) in R

How to automatically parsing date time in CSV with pandas

Pyspark read csv and combine date and time column and filter based on it

Date and Time change using csv column data in Python

How to sort date and time in one column in a JTable?

How to sort a column with Date and time values in Spark?

How to manipulate the time part of a date column?

How to import a CSV with a TIME column on SSMS (SQL)

how to make ElasticSearch treat keyword as string not date

Pandas: how to treat strange time format

How to update mysql database table each time csv file get uploaded - problem here is I cannot update the "date column"

How to convert in file csv date in specific column to unix date

How to groupby date in pandas and create time column associated by the date

How to check for current date, if the column having date and time?

how to count a column by month if the date column has time stamp?

How to add date column to already existing time column in python?

How to insert string to DATE column and TIME column from Ecto

Python - How to get a column 'duration' with start and end time column in csv?

Sorting csv column by date

Date & time text to column

TOP Ranking

Article

How to treat csv column as date-time

How to treat csv column as date-time

Can't pre-populate phone number and message body in SMS link on iPhones when SMS app is not running in the background

pump.io port in URL

Failed to listen on localhost:8000 (reason: Cannot assign requested address)

Unable to use switch toggle for dark mode in material-ui

grouping by column variables and appending a new variable based on condition

BigQuery - concatenate ignoring NULL

Spring Boot JPA PostgreSQL Web App - Internal Authentication Error

ngClass error (Can't bind ngClass since it isn't a known property of div) in Angular 11.0.3

Python Read Directory And Output to CSV

Remove adjacent duplicates in linked list in C

Angular 8. Unknown amount of http.get requests in array to call, must be sequential, what to use

How to keep curl session alive between two php processes?

Limit number of characters in uitextview

JMeter: Why get error when try to save test plan

Always setting the text cursor on Textbox

MTKView Displaying Wide Gamut P3 Colorspace

Vector input in shiny R and then use it

How to implement an authentication method using Spring Boot and JPA?

Laravel getting value from another table using eloquent

org.springframework.web.client.HttpClientErrorException: 401 null

When I click any button in my view page the form is submitted