AnsweredAssumed Answered

Substitute not searching full phrase

Question asked by Macz on Jun 23, 2018
Latest reply on Jun 23, 2018 by philmodjunk

I am having a issue wit a Substitute function. Because Print appears in   2 different options it is causing the output to combine so instead of 40 or 60 its 40 and 60. Is there a way to have the substitute to be the whole phase and not just some line? So "Print" and "Print and Electronic" would be treated as different things?

 

Here is my current setup

 

Substitute ( Table::Current Membership Type  ;

["Print" ; "40"] ;

["Print and Electronic" ; "60"] ;

["Canada" ; "45"] ;

["Canada & Electronic" ; "65"] ;

["World Wide" ; "60"] ;

["World Wide & Electronic" ; "80"] ;

["Electronic" ; "30"])

 

Thanks for any help!

Outcomes