Discussions

Solve problems, and share tips and tricks with other JMP users.

Choose Language Hide Translation Bar

Level I

Created: Mar 6, 2020 03:45 PM | Last Modified: Mar 7, 2020 1:47 PM (4929 views)

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

Community Manager

Community Manager

Community Manager

Created: Mar 6, 2020 03:56 PM | Last Modified: Mar 7, 2020 1:48 PM (4921 views) | Posted in reply to message from kmouloua 03-06-2020

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

Community Manager

Community Manager

Community Manager

Created: Mar 6, 2020 03:56 PM | Last Modified: Mar 7, 2020 1:48 PM (4922 views) | Posted in reply to message from kmouloua 03-06-2020

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

Level I

Mar 8, 2020 07:48 PM (4831 views) | Posted in reply to message from Ryan_Gilmore 03-06-2020

Thanks a lot i will try it out later