cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
JMP is taking Discovery online, April 16 and 18. Register today and join us for interactive sessions featuring popular presentation topics, networking, and discussions with the experts.
Choose Language Hide Translation Bar
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
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
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 

kmouloua
Level I

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

Thanks a lot i will try it out later