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
Re: How can i extract a specific "Word" From a column?Thanks a lot i will try it out laterRe: 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
