I have a field with different objectives. When the field contains 'Long Term Growth', I want to change it to 'Long-Term-Growth'. The formula below only works if Long Term Growth is the only word. Please help. Thanks
Safety, Income, Long Term Growth
if REGEX_Match( [Financial Objectives],"Long Term Growth",'') then "Long-Term-Growth"
elseif REGEX_Match( [Financial Objectives],"Maximum Yield",'') then "Maximum-Yield"
else [Financial Objectives]