nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

extracting month

aprilmayjune

Hello,

I have a column containing a timestamp in the following format:

Jan-01

Feb-01

How can I use formula to parse the month so that it would return:

Jan

Feb

I tried month(:Name("My-Column")) but it is giving me a red squiggly line.

Thank you so much for your help!

Accepted answers

txnelson

Your column is a character column, not a JMP numeric date column. To create a column that has just the month part of the character string, use the formula

substr( :"Month-Year"n, 1, 3 );

The structure I used gives the same results as :Name("Month-Year), but the structure I used is the supported structure moving forward

P.S. In the future when you provide an image of a data table, please provide the left hand panels of the data table. They provide more detail about the columns.

All comments

txnelson

Is the column you reference as "My-Column" a JMP numeric Date/time column? Attaching a sample of the data would really help. Or even an image of the table

aprilmayjune

Here is a screenshot of the data table. Thank you for looking into this! @txnelson

txnelson

Your column is a character column, not a JMP numeric date column. To create a column that has just the month part of the character string, use the formula

substr( :"Month-Year"n, 1, 3 );

The structure I used gives the same results as :Name("Month-Year), but the structure I used is the supported structure moving forward

P.S. In the future when you provide an image of a data table, please provide the left hand panels of the data table. They provide more detail about the columns.