Subscribe Bookmark RSS Feed

How to specify 2 digit year rule in JSL ?

connect01

Staff

Joined:

Oct 23, 2012

When importing an HTML table into JMP, I have the following

8858_2015-06-03_1.png

When changing the character data type to numerical with a date format, I get the following:

8859_2015-06-03_2.png

8860_2015-06-03_3.png

5 REPLIES
rleeper

Community Trekker

Joined:

Jun 3, 2014

JMP File menu

Select Preferences

Pick Text Data Files Tab on left

Under Two Digit Year Rule Pick a date range that matches your data range, i.e. 1920-2019.

connect01

Staff

Joined:

Oct 23, 2012

Thank you for your reply but I am not importing text file. I am importing HTML tables to JMP. All data are characters. When converting to numerical data, I have the problem.

rleeper

Community Trekker

Joined:

Jun 3, 2014

I tested this with an html character file before I answered your question and it worked just fine.

Craige_Hales

Staff

Joined:

Mar 21, 2013

I think the two digit year rule only applies during the import.  I don't think it is used for a later conversion of the column from character to numeric.

Craige
rleeper

Community Trekker

Joined:

Jun 3, 2014

When I import the column is automatically assigned to numeric, date format.

The HTML was saved as characters.

Are you changing the format during import?  I don't understand how you are importing a date as characters, JMP should import this as a numeric automatically.

Could you provide the actual HTML???  I just hand wrote one to check my answer before replying.