cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Browse apps to extend the software in the new JMP Marketplace
Choose Language Hide Translation Bar
godfeatha
Level I

CVS files with date columns open as characters

Hi all,

Many times I open a csv file that has a column that contains dates. Every once in a while when I a csv file, JMP opens it as a charcter. When I try to converrt it to date, I the vast majority of the rows for that comlumn are erased (null). Any idea why this is happening?

 

Thanks in advance!

11 REPLIES 11
godfeatha
Level I

Re: CVS files with date columns open as characters

Hello again,

Are here any programs that JMP uses that might affect the import of a file? I've used your solution and it works on several computers but there is 1 computer that gets the following error when opening the exact same csv file located on a sharedrive:

Invalid data encountered while importing these columns: MeasurementDate, Other_date.

Try importing the data again, but explicitly set the Data Type of those columns to Character.

 

We are both using JMP12 and have tried to match the "Text Data Files" settings on his computer to mine and have also tried to revery to the default settings as well.

Any suggestions?

 

Thanks in advanced!.

Craige_Hales
Super User

Re: CVS files with date columns open as characters

I'm just guessing...if this isn't the answer, you'll need tech support. I'm assuming you are using Windows, Mac probably has something similar. It is possible JMP is using the localization settings and something is different (language, perhaps.)

windows localization settingswindows localization settings

Craige