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

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

kmouloua — Sat, 07 Mar 2020 21:47:38 GMT

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

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

Ryan_Gilmore — Sat, 07 Mar 2020 21:48:12 GMT

You can create a column with the following formula,

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

For more information about the Word function, I would suggest

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

kmouloua — Sun, 08 Mar 2020 23:48:38 GMT

Thanks a lot i will try it out later