548522_en-US

liliconcom

Find few letter and replace whole word

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

Advanced Statistical ModelingAutomation and ScriptingData Blending and CleanupRe: Find few letter and replace whole wordThanks JthiRe: Find few letter and replace whole word

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