topic Re: extracting month in Discussions

extracting month

aprilmayjune — Sat, 10 Jun 2023 23:29:36 GMT

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!

Re: extracting month

txnelson — Fri, 30 Apr 2021 19:54:13 GMT

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

Re: extracting month

aprilmayjune — Fri, 30 Apr 2021 19:59:53 GMT

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

Re: extracting month

txnelson — Fri, 30 Apr 2021 20:11:29 GMT

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.