Gender conversion

Discussion created by pjohnson64 on Apr 29, 2017
Latest reply on May 2, 2017 by pjohnson64

I am using web direct and trying to replace the "find replace" script step. I am trying to use set field with "substitute". The problem I am having is that substitute does not look at whole words: he -> she (helium -> shelium). Is there away to make the substitute only look at whole words instead of parts. I tried spaces such as " He " and "He " but this does not work in the case that "He" is the first word in the field, but almost works. Any advice would be appreciated.