1 2 3 Previous Next 32 Replies Latest reply on Mar 24, 2014 2:27 PM by Shawn Wallwork

    Removing lots of characters from a string when the lengths vary??

    Renelle Risley

      I'm trying to replicate (and modify) the following Excel equation in Tableau 'speak'.  The data source is Excel.  I need to essentially strip off the beginning & end of the strings; however, the length varies - yet is based on 2 characters.  How do I do this??

       

      Source Field Data:

      16000 - Smith, Robert

      2068333 - Brandenburg, Francis J

       

      End Result Needed:

      Smith, Rob

      Brandenburg, Fra

       

      Excel Forumal Currently Used To Remove Left Numbers Only: 
      =RIGHT(J2, LEN(J2)-SEARCH("-",J2))

       

      I know there's a programmer out there who can help me!!!  Thank you.  Renelle

        1 2 3 Previous Next