First timer here, I am attempting to create a number of complex Label expressions in Arc Map. The problems is, how do you get a specific piece of a sting that is in a long text field. For example i am trying to say: if a field contains the string "ATM" then create a label "ATM. See below snippet.

No a simple DQ or Schema change will not work as I need to create labels based on all these categories and then push them to a SDE database ENV. I am trying to improve my python ability. Please any help would be much appreciated. Thanks.