https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Formula-Tool-Incorrectly-identifying-text/m-p/749452#M179682 <P>Right! Silly me <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span> Thanks</P> Wed, 21 Apr 2021 05:07:43 GMT HW1 2021-04-21T05:07:43Z https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Formula-Tool-Incorrectly-identifying-text/m-p/749446#M179677 <P>I have a formula tool with the formula:</P><P>&nbsp;</P><P>&nbsp;</P><LI-CODE lang="markup">IF Contains("Services / Site", [Value]) THEN "Services" ELSE Null() ENDIF</LI-CODE><P>&nbsp;</P><P>&nbsp;</P><P>It does not identify the text correctly.</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="HW1_0-1618979568306.png" style="width: 400px;"><img src="https://community.alteryx.com/t5/image/serverpage/image-id/181074iB44364D01D1984C2/image-size/medium?v=v2&amp;px=400" role="button" title="HW1_0-1618979568306.png" alt="HW1_0-1618979568306.png" /></span></P><P>&nbsp;</P><P>&nbsp;</P><P>Please find the attached workflow for an example</P><P>&nbsp;</P><P>Why is it happening?</P> Wed, 21 Apr 2021 04:33:34 GMT https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Formula-Tool-Incorrectly-identifying-text/m-p/749446#M179677 HW1 2021-04-21T04:33:34Z https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Formula-Tool-Incorrectly-identifying-text/m-p/749450#M179680 <P>Hi <a href="https://community.alteryx.com/t5/user/viewprofilepage/user-id/206344">@HW1</a>&nbsp;</P><P>&nbsp;</P><P>At first glance it looks like you have the contains function backwards. The syntax is contains([Field], string you want to find in the field)</P><P>&nbsp;</P><P>&nbsp;</P> Wed, 21 Apr 2021 04:59:03 GMT https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Formula-Tool-Incorrectly-identifying-text/m-p/749450#M179680 Luke_C 2021-04-21T04:59:03Z https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Formula-Tool-Incorrectly-identifying-text/m-p/749452#M179682 <P>Right! Silly me <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span> Thanks</P> Wed, 21 Apr 2021 05:07:43 GMT https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Formula-Tool-Incorrectly-identifying-text/m-p/749452#M179682 HW1 2021-04-21T05:07:43Z