I am attempting to return a portion of one text column that contains the entire value of another text column. Please see the attached file for more detail. Not entirely sure why I'm unable to get the contains function to work.
This can be achieved in much easier way by using find and replace tool.
If you want to use contains function then first you need to join both tables using Append fields and then apply formula
(IF Contains([Account - 2013], [Account - 2014]) THEN [Account - 2014]
elseif IsNull([Account - 2013]) then Null()
ELSE 'New' ENDIF).
However find and and replace is much easier way. Attaching workflow for find and replace method.