AnsweredAssumed Answered

Limit Substitute to Entire Word and not part of word

Question asked by bokenrosie on Nov 13, 2017
Latest reply on Nov 13, 2017 by philmodjunk

I have created an overly ambitious substitute command.  I have part of it posted below.  How can I limit it to only the entire word?  Ie Substute "Wtr" for "Water" but not create "Wtrberry" for "Waterbury".

 

Substitute(Notices::FormatterField;

["Series";"Ser"];

["Water";"Wtr"];

["Sewer";"Swr"];

["Limited";"Ltd"];

["District";"Dist"];

["Revenue";"Rev"];

["and";"&"])

Outcomes