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

[#1]

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

[#2 · Accepted solution]

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 

[#3]

Thanks a lot i will try it out later