2 Replies Latest reply: May 15, 2014 9:54 AM by Grant Perkins RSS

    Having trouble with Calculated Field

    Mark Starnes

      I'm having trouble capturing a part of a field.  I think I know how it should be done, but it's not working.  Here's a sample...



      EMAILLINE (Source)

      Adriana Montano (Adriana.Montano)    


      EMAILTAKE2 (Calculated Field)

      Adriana Montano (Adriana.Montano)      


      The calculated field is...



      I want the calculated field to be...



      Note - I've tried it without rtrim and that gives the same result.


      Thanks for your help.