Choose Language Hide Translation Bar
Highlighted
kmouloua
Level I

How can i extract a specific "Word" From a column?

Hi,

I am trying to create a column called "Flag" where the values are the first Word from column "Test type", i am using "_" as a delimiter for the search. How can i do this in JMP14?

Test type Flag
FINAL_PASS_FT2_-40 FINAL
FIRST_PASS_FT2_-40 FIRST
FT_COLD FT
FT_COLD FT
FINAL_PASS_8745_COLD_QA-40_2_FT FINAL
FIRST_PASS_8745_COLD_QA-40_2_FT FIRST
FT_ROOM FT
FINAL_PASS_8625_ROOM_TEST_2_FT FINAL
FIRST_PASS_8625_ROOM_TEST_2_FT FIRST
FINAL_PASS_8315_HOT_AT_105_1_FT FINAL
FIRST_PASS_8315_HOT_AT_105_1_FT FIRST

 

Thank you for your help

 

Karim

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Ryan_Gilmore
Community Manager Community Manager

Re: How can i extract a specific "Word" From a column?

You can create a column with the following formula,

 

Word(1, :Test type, "_")

For more information about the Word function, I would suggest If you learn only one Formula Editor function, Word() is the one 

View solution in original post

2 REPLIES 2
Highlighted
Ryan_Gilmore
Community Manager Community Manager

Re: How can i extract a specific "Word" From a column?

You can create a column with the following formula,

 

Word(1, :Test type, "_")

For more information about the Word function, I would suggest If you learn only one Formula Editor function, Word() is the one 

View solution in original post

Highlighted
kmouloua
Level I

Re: How can i extract a specific "Word" From a column?

Thanks a lot i will try it out later
Article Labels

    There are no labels assigned to this post.