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...

      Right(rtrim(EmailLine),(len(rtrim(emailline))-instr(rtrim(emailline),"(")))

       

      I want the calculated field to be...

      Adriana.Montano

       

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

       

      Thanks for your help.

       

      Mark