Forum Discussion
Incorrect date format when using text to columns
Craig, it looks like due to time added to that field. If time is not important for you (i.e. it always 0:00:00) you may open csv file and Text to Columns last column with space separator, remove time only column after that.
See result attached. If the time is important will find somethin else.
Here you go....I've had to change the extension from TXT to csv as it wont let me upload a txt one.
Craig, it looks like due to time added to that field. If time is not important for you (i.e. it always 0:00:00) you may open csv file and Text to Columns last column with space separator, remove time only column after that.
See result attached. If the time is important will find somethin else.
Well it didnt work exactly the way that you thought it would but I've managed to find a solution. Unfortunatley I havent been able to find the route cause of the problem so will have to carry out this work around every time I need to carry out the same action. Thanks for your help Sergei.
Craig, you may use Power Query (Get&Transform in 2016). It picks you txt file up and transforms correctly if for this column you use Change type->Using locale transformation.
You need to adjust the query only once, perhaps add name of txt file as parameter. After that no additional operations.
Attached is how it looks like, "Import File.txt" for this sample is in the root of C:\
- I too faced the same issue. got resolved using power query
