Forum Discussion

Craig Shankland's avatar
Craig Shankland
Copper Contributor
Oct 12, 2017
Solved

Incorrect date format when using text to columns

I've got an issue when I am importing a text file and using the text to columns function where its not recoginsing the correct date format in one of the columns.  The text file is generated from a sy...
excel
  • SergeiBaklan's avatar
    SergeiBaklan
    Oct 12, 2017

    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.

     

     

SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Oct 12, 2017

Hi Craig

 

On third step of the wuzard select correct date format for that column (US one in your case)

 

  • Craig Shankland's avatar
    Craig Shankland
    Copper Contributor
    Oct 12, 2017

    Hi Sergei - I've tried this method also but it still ends up with the same results.  It converst the ones with days less than or equal to 12 and ignores the rest !!  Very frustrating.

    • SergeiBaklan's avatar
      SergeiBaklan
      Diamond Contributor
      Oct 12, 2017

      Craig, could you please attach text file (or part of it) from which you import?

      • Craig Shankland's avatar
        Craig Shankland
        Copper Contributor
        Oct 12, 2017

        Here you go....I've had to change the extension from TXT to csv as it wont let me upload a txt one.

Resources