Using IF and Replace functions

Question

I have a workflow with data that looks like

company_namecontract_agreementcontract_agreement_IDMcdonalds789457529Popeyes78459 Zaxbys78421 Freddys84579 Popeyes 84124

I am trying to use the formula tool with "IF [customer_company_name] = 'Popeyes' THEN Replace([contract_agreement], "*", [contract_agreement_ID]) ELSE [contract_agreement] ENDIF". To replace all of the different contract agreements that popeyes may have but the current formula is not working. So the new data would look like.

company_namecontract_agreementMcdonalds78945Popeyes7529

Zaxbys78421Freddys84579Popeyes 7529

Any help is appreciated.

Thanks

binu_acs · Accepted Answer

@Travis_Ratliff One way of doing this

ShankerV · Accepted Answer

@Travis_Ratliff

Tried one tool solution, please check whether this helps you.

Input:

Output:

Many thanks

Shanker V