Automation to find exact word match in a text field
I'm exploring a way to precisely match the word "HE" within a text field used for comments. When the exact word "HE" appears in the text, I want to populate another field named "Gender" with the value "Male." However, I'm encountering a challenge where the search for "HE" also matches it within other words like "SHEET" or "SCHEDULE." I've attempted various methods, including using double and single quotations, brackets, and squiggly brackets, but none of these have resulted in the desired outcome. While I understand that I can create a helper field using a formula to address this, my preference is to achieve this using automation to avoid unnecessary additional fields.