topic Re: Find few letter and replace whole word in Discussions

Find few letter and replace whole word

chandankishor66 — Fri, 09 Jun 2023 15:58:56 GMT

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

jthi — Fri, 23 Sep 2022 08:37:06 GMT

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"
,
	""
);

chandankishor66 — Fri, 23 Sep 2022 09:51:51 GMT

Thanks Jthi