Find few letter and replace whole word

[#1]

Hello JMP community,

I am looking for your help to write a script who can find "PF"  OR "F" from column 1 and put "prefermentor: or "fermentor: name in column 2.

Regards,

Chandan

[#2 · Accepted solution]

With the provided information something like this should work and it is quite simple (create new formula column with it):

If(Ends With(:Column1, "PF"),
	"prefermentor",
Ends With(:Column1, "F"),
	"fermentor"
,
	""
);

[#3]

Thanks Jthi