4 Replies Latest reply on Mar 31, 2017 6:54 AM by jack.glavosek

    How to break a string based on position of special character?

    jack.glavosek

      I am working with a string of names that are pulled from a free text field.  I need to identify the first name only. 

      My definition of first name is "All characters from left to right until the end of the string or until we reach a special character."

       

      I've created a formula that looks for the location of the special character.  The problem I've found is when the string contains more than one special character.

       

      The attached workbook shows my 'Real Name' and the 'Goal Name.'  The 'New Name' field is my attempt at converting the real name into the goal name.

       

      There must be a better way for me to identify the position of a non-alpha character in my string.