BookmarkSubscribeRSS Feed
Choose Language Hide Translation Bar
connect01
Staff

How to specify 2 digit year rule in JSL ?

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

0 Kudos
5 REPLIES 5
rleeper
Community Trekker

Re: How to specify 2 digit year rule in JSL ?

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

Re: How to specify 2 digit year rule in JSL ?

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.

0 Kudos
rleeper
Community Trekker

Re: How to specify 2 digit year rule in JSL ?

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

0 Kudos
Craige_Hales
Staff (Retired)

Re: How to specify 2 digit year rule in JSL ?

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
0 Kudos
Highlighted
rleeper
Community Trekker

Re: How to specify 2 digit year rule in JSL ?

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.

0 Kudos